What is SCOPE_IDENTITY() in sql

Answer Posted / ranjani

Scope_Identity() returns last identity value inserted into
an identity column in the same scope.

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain difference between control flow and data flow?

526


What is perspective, have you ever created perspective? : sql server analysis services, ssas

493


What is merge join?

568


How display code or Text of Stored Procedure using Sql query in Sql Server ?

598


How to get the number of affected rows?

558






How to find the list of fixed hard drive and free space on server?

563


What structure can you implement for the database to speed up table reads?

706


Tell me what is log shipping?

564


What are the types of containers in ssis?

598


List out a number of the wants to setup a SQL Server failover cluster?

577


What are unicode character string data types in ms sql server?

597


How to enter binary string literals in ms sql server?

580


In what version of sql server were synonyms released?

502


What are cursors and when they are useful?

574


Sql server reporting services vs. Crystal reports.

96