What is @@Identity in sql?

Question Posted / deepthi

What is @@Identity in sql?..

Answer / deepthi

Is a system function that returns the last-inserted
identity value

Is This Answer Correct ?

23 Yes

1 No

More SQL Server Interview Questions

How to truncate the log in sql server 2012? : sql server database administration

How can we write or define DDL statements in Sql server and DML statements?

How to get a list of columns in a view using the "sp_help" stored procedure?

Selet all the data from table where last name is n of employee

How can delete duplicate records in cte in sql server?

Determine when an index is appropriate?

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

What is sql server used for?

How to remove duplicate rows from table?

What is inner join? Explain with an example?

What is the difference between stored procedure and user defined functions?

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

For more SQL Server Interview Questions Click Here