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

How to Get the last identity value used

Question Posted / guest

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

Please Help Members By Posting Answers For Below Questions

What is the purpose of linked server configuration in sql server?

1018

What is the Main Difference between ACCESS and SQL SERVER?

1113

Explain sql delete command?

1028

What is 1nf 2nf?

993

What are the general features of sql server management studio? : sql server management studio

1057

What is the user of Primary key?

959

Do you have any idea about the tcl commands?

945

You want to use a perspective in an mdx query. How do you select the perspective?

239

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

878

Can a synonym name of a table be used instead of a table name in a select statement?

1008

What is partition index in sql server?

1097

What is perspective, have you ever created perspective? : sql server analysis services, ssas

896

What is normalization and its types?

999

List the data types available in mssql?

1016

How to use the inserted and deleted pseudo tables?

945