Interested to Buy Any Domain ? << Click Here >> for more details...
What is SCOPE_IDENTITY() in sql
- 4 Answers
- 12346 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 |
What is oltp (online transaction processing)?
What is the difference between truncate and delete commands?
Explain in brief how sql server enhances scalability of the database system?
Which is better statement or preparedstatement?
What is a transact-sql statement batch in ms sql server?
how to get the rowid/rownumbes of a table in sqlserver
What is NOT NULL Constraint in sql server 2012?
What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Why use identity in sql server?
What is difference between unique and primary key?
What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
