select @@identity @@identity is global variable

How to Get the last identity value used

Question Posted / laxman

4 Answers
9093 Views
I also Faced
E-Mail Answers

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 are temporal tables in sql server 2016?

932

Sql server reporting services vs. Crystal reports.

140

How to send a ssrs report from ssis?

183

How many levels of sp nesting is possible?

1101

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

1065

What is meant by Active-Passive and Active-Active clustering setup?

1273

how to trace the traffic hitting a sql server? : Sql server database administration

1956

What are different types of data sources?

1085

What is the syntax for encrypting a column in SQL Server?

1175

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1184

What are acid properties of transaction?

997

what stored procedure would you use to view lock information? : Sql server administration

1024

How do you improve the performance of a SQL Azure Database?

137

What are the default system databases in sql server 2000?

1084

How does recursive cte works in sql server?

1059