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

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1206

How do you know if sql server is running on your local system?

1043

What is indexing and its types?

1017

Can we hide the definition of a stored procedure from a use?

1224

Explain differences between web edition and business edition?

119

How will you decide the active and passive nodes?

1129

What is the use of builtinadministrators group in sql server? : sql server security

1049

What are audit control procedures?

990

When I run the sql server 2000 setup, it just hangs. What do I do?

1082

How to update a field in SQL after ALTERING a row?

1232

What is the difference RDBMS and Graph Database?

1047

Difference between 2NF &3NF ?

1085

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1066

What is cursor in ms sql server?

1147

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1137