What is SCOPE_IDENTITY() in sql

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is spatial nonclustered index

550


Describe how to use linked server?

548


What is recompile sql server?

573


Can You Use Data Mining Models In Ssrs?

97


What is the difference between rank and dense_rank?

507






How do I connect to sql server database?

482


What is a derived table?

517


What do you mean by table and field in sql?

558


What do you understand by physical_only option in dbcc checkdb?

581


Can sql servers link to other servers?

567


What are the advantages of sql azure?

116


Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

585


What is a heap?

621


What are the events recorded in a transaction log?

508


What is PROJECTION Operation?

613