Returns the most recently created identity value for the tables in the cur

What is the use of SCOPE_IDENTITY() function?

Question Posted / saravakumar

Answer Posted / saravakumar

Returns the most recently created identity value for the
tables in the current execution scope.

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is faster join or union?

1131

Why use view instead of a table?

896

Why should we go for stored procedures? Why not direct queries?

1044

what protocol both networks use? : Sql server database administration

944

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2725

How to specify the collation for a character data type in ms sql server?

980

What is a partition key?

901

What is a sql join?

961

What are subquery and its properties?

989

What is the need for group functions in sql?

1026

What are points to remember while using the fillfactor argument?

922

In case you have filters in your report, when filters will be applied in cached report instance?

105

What does this statement do @@rowcount?

935

How to create database with physical files specified in ms sql server?

967

What are the advantages of using third-party tools?

933