Scope_Identity() returns last identity value inserted into an identity co

What is SCOPE_IDENTITY() in sql

Question Posted / ranjani

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

Please Help Members By Posting Answers For Below Questions

What is indexing a document?

1030

How to search for a string in all stored procedure in sql server?

983

What is the most common type of join?

982

What is the difference between ‘having’ clause and a ‘where’ clause?

1032

What does asynchronous call backs means?

1139

Explain what is “asynchronous” communication in sql server service broker?

904

What encryption security is available in sql azure?

101

What is sql injection and why is it a problem? : sql server security

1117

What is difference between getdate and sysdatetime in sql server 2008?

1043

Can we call stored procedure in trigger?

940

How many types of local tables are there in sql server?

917

What is named calculation? : sql server analysis services, ssas

966

Explain syntax for disabling triggers?

1025

What is a transactions?

1033

What is the web service used for reporting services?

123