1 2 |
SELECT SCOPE_IDENTITY() AS [SCOPE_IDENTITY] SELECT @@IDENTITY AS [@@IDENTITY] |
1 |
SCOPE_IDENTITY() is a better solution for most circumstance. |
References:
- http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/
- http://www.dotblogs.com.tw/ajun/archive/2008/04/01/2504.aspx
Note: In Access it only support @@IDENTITY
Example:
1 2 |
set rs = Server.CreateObject("ADODB.RecordSet") rs.open sql, conn, 1, 1 |