How to Get the last identity value used
Answers were Sorted based on User's Feedback
Answer / guest
the last identity value used in an insert can be retrieved
with the @@identity function.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / chandramohan
scope_identity() would be the currect answer. To avoid potential problems professionals suggests this method since it returns the recently added value.
Is This Answer Correct ? | 1 Yes | 1 No |
What are different types of join?
how many clustered indexes can be created on a table? : Sql server database administration
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...
7 Answers ADP, Satyam, Tech Mahindra,
Why use “nolock” in sql server?
How do database indexes work?
What is database mirroring?
How to get last system shutdown time in Sql server when restarted system?
How to add an address record into adventureworkslt?
what is for foreign key ??
4 Answers CarrizalSoft Technologies, Sabic,
What is acid mean in sql server?
When would you use a before or after trigger?
What are statistics?