What is @@Identity in sql?

Answer Posted / deepthi

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

Is This Answer Correct ?    23 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of “join” in sql server?

574


Are semicolons required at the end of sql statements in sql server 2005?

570


How can you check the version of sql server?

564


Where sql server usernames and passwords are stored in a sql server?

498


Write down the syntax and an example for create, rename and delete index?

538






How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

556


What is a db view?

520


What are out-of-range errors with date and time literals?

556


Explain what are the basic functions for master, msdb, model, tempdb databases?

532


What are transactions in sql?

556


Why do we use stored procedures in sql server?

499


What is sql server schema compare? How we can compare two database schemas?

566


how to do partition in sqlserver

1975


What is data modeling and Reterminal integrity?

1494


What is the native system stored procedure to execute a command against all databases?

542