What is SCOPE_IDENTITY() in sql
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What are the different types of sql server replication? : sql server replication
Explain data warehousing in sql server?
Does a sql server 2005 select statement require a from?
What is sql collation?
What is the cartesian product of the table?
Is it possible to have clustered index on separate drive from original table location?
What do you understand by recursive stored procedures?
What are the types of stored procedures in an sql server?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
hi,i want t0 knom d syntax for a super key with an example
Can two tables share the same primary key?
What are subqueries in sql server?