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

What are tables in sql server?

0 Answers  


Can you tell me some of the common replication dmv's and their use? : sql server replication

0 Answers  


You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

0 Answers  


How to create a simple stored procedure in ms sql server?

0 Answers  


What is the osql utility?

0 Answers  






What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  


What is triggers and stored procedures?

0 Answers  


explain different types of jions with examples briefly?

1 Answers   Zensar,


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  


Tell me what is log shipping?

0 Answers  


how to trace the traffic hitting a sql server? : Sql server database administration

0 Answers  


Explain what is the function of sql server agent windows service?

0 Answers  


Categories