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 is the data type of time?

504


How to get the definition of a view out of the sql server?

493


What is the sql server 2000 version number?

543


How do I view a trc file?

493


How does Report Builder support Analysis Services cubes?

110






What is the process of normalization?

547


What is difference between table aliases and column aliases? Do they affect performance?

503


What are the types of dml?

545


What is awe?

561


What is a primary key?

534


Describe how to use linked server?

535


What is amo? : sql server analysis services, ssas

657


How to get the definition of a user defined function back?

558


How do I get Report Builder to generate a parameter that can be set by users viewing the report?

100


Explain what are the events recorded in a transaction log?

544