What is @@Identity in sql?



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

Post New Answer

More SQL Server Interview Questions

Write a program using SQL queries to find a unique entry in a table.

0 Answers   Tech Mahindra,


What does sql server mean?

0 Answers  


Does union all remove duplicates?

0 Answers  


What is model database in sql server?

0 Answers  


Which are the important points to note when multilanguage data is stored in a table?

0 Answers  






What is partition in sql server?

0 Answers  


What is a field name?

0 Answers  


Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,


Explain the various types of concurrency problem?

0 Answers  


What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  


How to assign new column names in a view?

0 Answers  


What are the system database in sql server 2005?

0 Answers  


Categories