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

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1040

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

962

What is snapshot replication?

1008

Tell me extended events in sql server 2008?

954

What is trace flag in sql server?

979

How to rename databases in ms sql server?

1133

Are resultset updatable?

904

Delete duplicate rows without using rowid.

1501

What protocol does sql server use?

893

What is nested transaction?

1056

Explain the third normal form(3nf)?

903

Explain about integration services of Microsoft SQL server?

993

What are the key configuration files for sql server reporting services ?

163

Explain the ways to controlling cursor behavior?

883

How can I check if a view exists in a sql server database?

990