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

Which tcl commands are available on the sql server?

1074

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1134

Explain datetimeoffset data type in sal server 2008?

899

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2061

What is onf in normalization form?

1049

Are all views updatable ?

1143

What is the difference between lock, block and deadlock? : sql server database administration

1036

What are 3 ways to get a count of the number of records in a table?

1069

How to apply filtering criteria at group level with the having clause in ms sql server?

993

Explain database normalization?

1212

Is it possible in sql table to have more than one foreign key?

1025

What are sub reports?

201

what is normalization? : Sql server database administration

1087

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

167

How real and float literal values are rounded?

1149