What is the use of SCOPE_IDENTITY() function?

Answer Posted / saravakumar

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

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different normalization forms?

800


What is public role in sql server?

746


How many types of attribute relationships are there? : sql server analysis services, ssas

773


How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

858


Explain sql delete command?

790






What do you know about normalization and de- normalization?

637


What is a result set object returned by mssql_query()?

736


What is query and its types?

683


What is sql server transaction log file?

705


How to create a stored procedure with a statement block in ms sql server?

747


How to convert binary strings into integers in ms sql server?

724


What does normalization do to data?

723


What is the cartesian product of table?

729


Does partitioning ssd reduce performance?

639


How to return the top 5 rows from a select query in ms sql server?

779