Inserted ID in MS SQL Server | Rex's Personal Site

SELECT SCOPE_IDENTITY() AS [SCOPE_IDENTITY]
SELECT @@IDENTITY AS [@@IDENTITY]

1 2	SELECT SCOPE_IDENTITY() AS [SCOPE_IDENTITY] SELECT @@IDENTITY AS [@@IDENTITY]

SCOPE_IDENTITY() is a better solution for most circumstance.

1	SCOPE_IDENTITY() is a better solution for most circumstance.

References:

Note: In Access it only support @@IDENTITY

Example:

set rs = Server.CreateObject(&quot;ADODB.RecordSet&quot;)
rs.open sql, conn, 1, 1

1 2	set rs = Server.CreateObject("ADODB.RecordSet") rs.open sql, conn, 1, 1