什么是SELECT @@IDENTITY将返回，如果我有事务性查询与IsolationLevel.多个同时查询的快照

我有一个表，有多个应用程序访问多个事务，我希望这些多个应用程序/事务得到每个主键/身份由执行该事务的应用程序相应地插入。由于某种原因，我不能使用SCOPE_IDENTITY，这就是为什么我最后的排序是使用@@IDENTITY。对于事务性查询，我实现了IsolationLevel。为每个事务创建快照，以避免阻塞。

现在我的问题是，在这种情况下，每个事务是否正确并相应地返回@@IDENTITY。

交货。我有三个查询同时执行:

Transactional1 Query Insert with expected return Identity 100;
• Transactional2查询插入并返回Identity 102;
• Transactional3 Query Insert with expected return;

它会像这样相应地返回Identity吗?this is my aim

• Transaction1 - 100
• Transaction2 - 102
Transaction3 - 103

或者它可能像这样发生?这是我最害怕发生的事

• Transaction1 - 102
• Transaction2 - 103
• Transaction3 - 101

这个现有的触发器是SCOPE_IDENTITY返回标识的原因，即使我的代码和查询中有SCOPE_IDENTITY。

ALTER trigger [dbo].[CustomerAddressesInsertVIds] on [dbo].[CustomerAddresses]
instead of insert
as
begin
set nocount on
insert into [dbo].[CustomerAddresses]
([CustomerID], [AddressTypeID], [CustomerAddressID], [AddressNameType], [Name], [ContactID], [Address1], [Address2], [Address3], [City], [County], [State], [Country], [Zip], [Phone1], [Phone2], [Fax1], [Fax2], [CreateDate], [CreateUser], [MaintenanceDate], [MaintenanceUser], [LastOrderDate], [DeleteOnDate], [SyncStatus], [SyncDate], [SyncUser], [ERPID], [CreateCustomerID], [CreateContactID], [MaintenanceCustomerID], [MaintenanceContactID], [Active], [Deleted], [LockUser], [LockSessionID], [LockDate], [InUse], [AddressTypeVId], [CustomerVId])
select
coalesce([CustomerID], (select [CustomerID] from [dbo].[Customers] where [CustomerVId]=inserted.[CustomerVId])), coalesce([AddressTypeID], (select [AddressTypeID] from [dbo].[AddressTypes] where [AddressTypeVId]=inserted.[AddressTypeVId])), [CustomerAddressID], [AddressNameType], [Name], [ContactID], [Address1], [Address2], [Address3], [City], [County], [State], [Country], [Zip], [Phone1], [Phone2], [Fax1], [Fax2], [CreateDate], [CreateUser], [MaintenanceDate], [MaintenanceUser], [LastOrderDate], [DeleteOnDate], [SyncStatus], [SyncDate], [SyncUser], [ERPID], [CreateCustomerID], [CreateContactID], [MaintenanceCustomerID], [MaintenanceContactID], [Active], [Deleted], [LockUser], [LockSessionID], [LockDate], [InUse], coalesce([AddressTypeVId], (select [AddressTypeVId] from [dbo].[AddressTypes] where [AddressTypeID]=inserted.[AddressTypeID])), coalesce([CustomerVId], (select [CustomerVId] from [dbo].[Customers] where [CustomerID]=inserted.[CustomerID]))
from inserted
end