What is SCOPE_IDENTITY() in sql

Answer Posted / vipul

When new row insert into table its we can get value of auto
increment column using SCOPE_IDENTITY()

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why would you call update statistics?

577


How can you tell if a database object is invalid?

610


Can we shrink data file in sql server?

531


How many types of dimensions are there and what are they? : sql server analysis services, ssas

560


How to edit table in sql server 2017?

506






What is sql server replication? : sql server replication

532


Which command is used for user defined error messages?

558


What is the difference between Normalization and De-normalization?

556


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1781


What is compression - row-level and page-level compression?

528


What does it mean to normalize a database and why would you do it?

524


What does nvl stand for?

556


Explain features of analysis services?

520


What is an execution plan? When would you use it?

571


What is the use of partition by in sql server?

507