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

Do you know what guidelines should be followed to help minimize deadlocks?

531


explain how to create a new schema in a database? : Sql server database administration

574


Explain different types of collation sensitivity?

522


How is table type constraint applied to a table?

539


How to generate create view script on an existing view?

553






What is difference between cte and view?

516


How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

558


Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

134


Explain how to use linked server?

555


Why I can not enter 0.001 second in date and time literals in ms sql server?

531


What is sql server profiler?

561


Explain what is analysis service repository?

528


What are the disadvantages of primary key and foreign key in SQL?

620


What is the difference between nvl and nvl2?

542


How to create an index on an existing table in ms sql server?

491