What is the use of SCOPE_IDENTITY() function?

Question Posted / saravakumar

2 Answers
6393 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the use of SCOPE_IDENTITY() function?..

Answer / saravakumar

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

Is This Answer Correct ?

4 Yes

1 No

What is the use of SCOPE_IDENTITY() function?..

Answer / bhupesh

Returns the last identity value inserted into an identity
column in the same scope. A scope is a module: a stored
procedure, trigger, function, or batch.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer

More SQL Server Interview Questions

What is co-related sub query?

0 Answers

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers

What is BLOCK statements in SQL?

0 Answers HCL,

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

0 Answers

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers eFunds,

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

0 Answers

Get Current System Date Time

2 Answers

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

0 Answers

What are the events recorded in a transaction log?

0 Answers

What are primary keys and foreign keys?

4 Answers

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

0 Answers

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 Answers

For more SQL Server Interview Questions Click Here