What is SCOPE_IDENTITY() in sql
- 4 Answers
- 10466 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
Which institute is best for SQL Server 2005 Training?
What do you mean by data integrity?
How to optimize stored procedure optimization?
What is table level trigger?
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.
Can a table have 2 foreign keys?
What language is sql server written in?
What are relationships and mention different types of relationships in the dbms
What are the type of Indexes? which one is best, why?
How do I find the query plan in sql server?
What is role playing dimension with two examples? : sql server analysis services, ssas
Where are full-text indexes stored?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
