What will be returned with @@identity T-Sql?

Posted By: Avi

Date: 1 October 2010 11:41:07 AM

Answer:

It will return the last inserted identity value. It will return a numeric value. So whenever a row is inserted or slected or bulk is copied down @@identity will return the last identity values generated by the statements.
Posted By: avibtech	Date: 1 October 2010 11:41:07 AM

Post a better Answer if you have

Name*

E-mail* (Will show your Gravatar icon)

Website

Country

Notify me when new Answers are added

Enter the text as shown in the image

The table was deleted. Now is there any way to get it back?

Yes, the logs can be used to fetch the deleted table.For this one has to use some some external tool....

Category: SQL Server

Date: 10/1/2010 12:02:08 PM

With the help of @@version one can determine the Service pack installed on th SQL Server. For this y....

Category: SQL Server

Date: 10/1/2010 12:01:08 PM

Lots of options exists to move the data or databases. Depending on our requirements we can opt for t....

Category: SQL Server

Date: 10/1/2010 12:00:08 PM

RAID is an acronym for "Redundant Array of Independent Disks". It is used to provide fault....

Category: SQL Server

Date: 10/1/2010 11:59:08 AM

There are no specific commands or methods in SQL server to retrieve the data from the log files. Som....

Category: SQL Server

Date: 10/1/2010 11:58:08 AM

View All Questions >>

Signup for our weekly email newsletter