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 the recovery model?

1061

Explain differences between web edition and business edition?

119

How many cores do I need for sql server 2016?

953

Define outer join?

1047

What Are the Main Features of SQL Azure?

121

How will you hide an attribute? : sql server analysis services, ssas

1012

Explain left outer join and right outer join?

1092

What is instead of dml trigger?

1059

What do you mean by a Composite primary key?

1191

What are the mathematical functions supported by sql server 2005?

1127

Does a sql server 2005 select statement require a from?

1073

what is isolation level at dead lock?

2213

How to create a user name in a database?

1103

how to overcome kernel isssues

1687

How does stuff differ from the replace function?

1064