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  






Categories