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

What is @@Identity in sql?

Question Posted / deepthi

Answer Posted / deepthi

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

Is This Answer Correct ?

23 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What objects does the fn_my_permissions function reports on? : sql server security

1035

Does partitioning ssd reduce performance?

895

what is database replication? : Sql server database administration

1066

Difference between connected and disconnected database in .net with sql server?

1097

how you can move data or databases between servers and databases in sql server? : Sql server administration

965

How do I connect to sql server database?

1014

How to find which stored procedure is currently running in sql server?

996

How column data types are determined in a view?

961

Mention the different authentication modes in sql server.

1056

What are the advantages of sql azure?

140

How can you list all the columns in a database?

931

How do you create an execution plan?

948

What is role playing dimension with two examples? : sql server analysis services, ssas

1006

How to reaname table name without using sp_Rename in sql server..?

996

What are the tables in sql?

1087