What is the use of SCOPE_IDENTITY() function?

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 are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

2 Answers   IBM,

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   L&T, IBM,

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  

sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  

Explain SELF JOIN ?

3 Answers   ADP,

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

how to delete duplicate rows in sql server2005

7 Answers   HCL, CTS, Cisco, IBM,

Diffrence between DTS vs SSIS

2 Answers   Infosys, IBM,

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

Can you explain some of the DTS problems?

1 Answers   UBS, Wipro,

how can i view structure of table in sql server? tell me that query.

10 Answers