scope identity will give you the last generated value for the current ses

What is SCOPE_IDENTITY() in sql

Question Posted / cow

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

Please Help Members By Posting Answers For Below Questions

What is the use of partition by in sql server?

933

What are subqueries in sql server?

1121

What is the purpose of sql profiler in sql server?

1020

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1145

Explain what is meant by replication of database?

1032

How do you Implement SSIS Packages in your Project?

1931

Can a function call a stored procedure in sql server?

960

What are out-of-range errors with date and time literals?

1030

What is a ddl statement?

913

What is faster join or union?

1212

How do I port a number to sql server?

1038

What is the difference between seek predicate and predicate?

1060

Tell me can we use custom code in ssrs?

1002

When should you use an instead of trigger?

955

What is the full form of ddl?

926