@@PACK_RECEIVED

In this example,

returns the

from the table (current scope), while

returns the

from the table (trigger scope). For most application scenarios, is the safer choice because it isn’t affected by trigger activity.

SCOPE_IDENTITY (Transact-SQL)

IDENT_CURRENT (Transact-SQL)

System Functions by category for Transact-SQL

CREATE TABLE (Transact-SQL)

INSERT (Transact-SQL)

SELECT (Transact-SQL) integer sp_monitor

SCOPE_IDENTITY()

ProductID

Products

@@IDENTITY

AuditID

ProductAudit

SCOPE_IDENTITY()

SELECT
ProductID,
'INSERT'
FROM inserted;
END
;
GO
-- Insert a product and compare identity values
INSERT
INTO dbo.Products (ProductName)
VALUES (
'Test Product'
);
SELECT
@@
IDENTITY
AS
[@@
IDENTITY
],
SCOPE_IDENTITY()
AS
[SCOPE_IDENTITY];
GO