It will return the value of Auto Increment column , for the newly inserte

What is SCOPE_IDENTITY() in sql

Question Posted / deepthi

Answer Posted / deepthi

It will return the value of Auto Increment column , for the
newly inserted row value.

Is This Answer Correct ?

35 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Explain Normalization and DE normalization

606

How to find the service pack installed? : sql server database administration

546

How to test subquery results with the exists operator?

558

What is right outer join in sql server joins?

686

What does REVERT do in SQL Server 2005?

558

What is bcp? When does it used?

545

What is the difference between writing data to mirrored drives versus raid5 drives

507

Describe the left outer join & right outer join. : sql server database administration

584

Does group by sort data?

511

What is difference between global temporary tables and local temporary tables?

658

How to rebuild the master database?

573

Please explain what is “asynchronous” communication in sql server service broker?

506

What are indexers?

623

What is row_number()?

578

Explain Geometry datatype in sql server 2008 with example

586