Reputation: 19307
What is the equivalent of the mysql_insert_id() MySQL function in sqlserver ?
Upvotes: 0
Views: 1171
Reputation: 166396
Have a look at the following
SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record
IDENT_CURRENT (Transact-SQL)
@@IDENTITY (Transact-SQL)
SCOPE_IDENTITY (Transact-SQL)
Upvotes: 2