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 each E-R model constructs can be mapped to the relational model?

560


What are built in functions?

580


What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

692


How do I manually uninstall an instance of sql server 2016?

549


What is key set driven?

540






How to list all tables in the database using odbc_tables()?

569


What do you understand by replication in sql server? Mention the different types of replication in sql server.

509


Explain tables in SQL Azure?

96


Explain the difference between function and stored procedure?

517


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

564


What is code near application topology?

197


Relational calculus is what type of language?

580


What is user-defined scalar function?

558


Explain the functionalities that views support?

696


What are translations and its use? : sql server analysis services, ssas

606