How you can get the last identity value inserted in any table ?

Posted by Neeks on 3/5/2009 | Category: Sql Server Interview questions | Views: 10402

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

SQL Server 2000 has a System Variable @@IDENTITY which gives the last identity element value inserted in any table

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What is the maximum size of an SQL Server 2000 Dat ...

Next > : What are the limits of Sql Server 2000?

Comments or Responses

Posted by: Vuyiswamb on: 3/31/2009

The @@IDENTITY will not always bring you the last inserted identity Column. The one way that will surely bring you the last identity value is like this

select IDENT_CURRENT ('mytable')

More Interview Questions by Neeks

What are the limits of Sql Server 2000?
What is the Maximum number of input and output parameters in Stored pr ...
10 Steps to a Successful Interview
State some limitations of style sheets?
What event can you subscribe to if you want to display information fro ...
Which is not the step to create custom SOAP (Simple Object Access Prot ...
What is DESCRIBE command in SQL Server 2005? What is its purpose? How ...
How do you optimize stored procedures in SQL Server 2005

Latest Interview Questions

Should we use table tag to design the layout of the webpage?
How to create a ListBox in HTML?
How to create a DropDown list box?
How to display numbered list in HTML?
How to write bulleted point in HTML?
How to refer the .css file in the web page?
How to display the web page icon in the browser?
How to add javascript file reference in the web page?
More ...