How to Get the last identity value used

Answer Posted / guest

the last identity value used in an insert can be retrieved
with the @@identity function.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger and different types of Triggers?

806


What is the difference between stored procedure and user defined functions?

849


What are information schema views?

738


What are the differences between left join and inner join in sql server?

770


What are the common performance issues in sql server?

661






Explain a join?

780


Which is the main third-party tool used in sql server?

662


When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

756


What are parameterized reports?

176


Name the different type of indexes in sql?

714


What functions can a view be used to performed?

794


Explain “row_number()” in sql server with an example?

719


Can we insert data into view sql server?

716


What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

743


What are binary string data types in ms sql server?

817