When new row insert into table its we can get value of auto increment col

What is SCOPE_IDENTITY() in sql

Question Posted / vipul

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

Please Help Members By Posting Answers For Below Questions

How to integrate the ssrs reports in application?

990

What is oltp (online transaction processing)?

1008

What is dbcc? Give few examples.

1039

What is the use of nvl work?

1004

Is truncate autocommit?

938

How to create view in stored procedure sql server?

1017

What is precedence constraint?

983

What is difference between aggregate and analytic function?

938

What the different components of Replication and what is their use?

1070

what's new in sql server 2016?

945

Explain throw statement in sql server 2008?

998

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1036

What is the default value of an integer data type in sql server 2005?

953

How can you hide the sql server instances?

1021

Mention the differences between sql server and mysql.

1016