What is SCOPE_IDENTITY() in sql

Question Posted / deepthi

4 Answers
12328 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is SCOPE_IDENTITY() in sql..

Answer / deepthi

It will return the value of Auto Increment column , for the
newly inserted row value.

Is This Answer Correct ?

35 Yes

3 No

What is SCOPE_IDENTITY() in sql..

Answer / 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

What is SCOPE_IDENTITY() in sql..

Answer / ranjani

Scope_Identity() returns last identity value inserted into
an identity column in the same scope.

Is This Answer Correct ?

7 Yes

2 No

What is SCOPE_IDENTITY() in sql..

Answer / cow

scope identity will give you the last generated value for
the current session/scope. Note that @@identity is across
sessions.

Is This Answer Correct ?

3 Yes

2 No

Post New Answer

More SQL Server Interview Questions

diffrence between Cluster Index and non Cluster Index

3 Answers Wipro,

what changed between the previous version of sql server and the current version? : Sql server database administration

0 Answers

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers Satyam,

Explain about Views?

0 Answers Infosys,

How to call a function from a stored procedure in SQL Server ?

0 Answers HCL,

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

0 Answers

Explain about sql server login?

0 Answers

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers Value Labs,

What is referential integrity? What are the advantages of it?

4 Answers Descon, Digital Domain,

Explain the various types of concurrency problem?

0 Answers

What is tempdb in sql server?

0 Answers

Write an SQL query to obtain the 2nd highest salary.

0 Answers Akamai Technologies,

For more SQL Server Interview Questions Click Here