What is the use of SCOPE_IDENTITY() function?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to insert and update data into a table with "insert" and "update" statements?

699


How to turn on the mssql api module in php?

757


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

800


What is 4nf in normalization form?

754


What is store procedure? How do they work?

760






What is indexed view? How to create it?

757


What is a view in sql?

756


What is temporary stored procedure?

704


Why would you use sql agent?

879


Explain filtered indexes benefits?

772


What is difference between getdate and sysdatetime in sql server 2008?

778


Why SQL Agent is used?

797


What is meant by datasource?

683


What is a trigger and its types?

730


Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

749