select @@identity @@identity is global variable

How to Get the last identity value used

Question Posted / laxman

Answer Posted / laxman

select @@identity

@@identity is global variable

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is create command?

959

Who developed sql server?

918

How to provide values to user defined function parameters?

997

What are the restrictions applicable while creating views? : SQL Server Architecture

1007

What are the different types of sql server replication? : sql server replication

1236

Differentiate between mongodb vs. Sql server?

1072

What is an indexing technique?

906

What is database architecture? : SQL Server Architecture

1015

Explain about builtinadministrator?

1034

What are recommended options to be used while using db mirroring? : sql server database administration

1124

What is 'write-ahead log' in sql server 2000 ?

1030

What is the difference between a function and a trigger?

1060

What are the different types of data sources in ssrs?

196

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

953

What is difference between equi join and inner join?

916