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

What are the different types of replication are there in sql server 2000?

822


Can we check locks in database? If so, how can we do this lock check?

749


How do I open port 1433?

739


What is the default value of an integer data type in sql server 2005?

790


What do you understand by recursive stored procedures?

781


How to specify the collation for a character data type in ms sql server?

785


Explain what is analysis service repository?

762


What is extended stored procedures?

762


How many full-text indexes can a table have?

766


How to provide login information for a new odbc dsn?

732


What is ms sql server reporting services?

770


How do I connect to sql server database?

734


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

1654


What is the most common trace flags used with sql server?

735


What is a Join and explain its types?

869