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 retrieve error messages using odbc_errormsg()?

1107

Tell me what is difference between clustered and non clustered index?

981

What is sqlservr.exe - process - sql server (sqlex?press)?

1154

What is row_number()?

1050

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1351

What are the diifferences between the ms sql server vs mysql?

1236

Why olap is used?

1035

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1005

What Are the Main Features of SQL Azure?

121

How many types of subqueries are there in sql server?

1033

What is dbcc updateusage?

1257

Are connections to sql server encrypted?

1055

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1120

What is the difference between createstatement and preparedstatement?

999

Write SQL queries on Self Join and Inner Join.

1215