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 bcnf normalization form?

1157

What is Extended user-defined?

1026

what is spatial nonclustered index

1032

What do you mean by normalisation?

1098

Write a program to fetch first 10 records from a file?

1059

Show Practically Sql Server Views are updatable?

1184

How many servers can we create in a single subscription?

162

How many types of functions are there in sql server?

984

Tell me can we use custom code in ssrs?

1048

What is the ‘fillfactor’?

1013

Which table keeps information about stored procedures?

979

what is a transaction? : Sql server database administration

1045

How to use transact-sql statements to access the database engine?

1119

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1111

What are the different types of cursor?

1143