How to Get the last identity value used

Answer Posted / laxman

select @@identity

@@identity is global variable

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rtm version in sql server?

694


What is apply operator in sql?

757


When would you use a before or after trigger?

658


What is a virtual table in sql?

708


What is #table in sql server?

739






how to create a scrollable cursor with the scroll option? : Sql server database administration

766


How to delete an existing row with delete statements in ms sql server?

766


Mention the command used to rename the database.

720


Why variables called the most powerful component of ssis?

795


Explain what is row_number function?

754


What’s the use of custom fields in report?

717


Which autogrowth database setting is good?

790


What is page-level compression?

719


Why I have to use stored procedures?

780


How many databases can we create in a single server?

199