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

What is sql language?

1027

What is the difference between functions and scalar functions?

1124

What is raid? : SQL Server Architecture

1101

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1832

How to assign new column names in a view?

863

What is ddl and dml commands?

849

Explain the ways to controlling cursor behavior?

872

How to restore performance issues and how to check?

1949

You want to implement the one-to-one relationship while designing tables. How would you do it?

911

What stored by the msdb?

953

What do you know about normalization and de- normalization?

870

Which are the important points to note when multilanguage data is stored in a table?

910

Can we insert data into view sql server?

883

Explain “row_number()” in sql server with an example?

948

What is difference between clustered and non clustered index?

920