Interested to Buy Any Domain ? << Click Here >> for more details...
What is SCOPE_IDENTITY() in sql
- 4 Answers
- 12162 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 does the automatic recovery do?
Explain having clause and where clause?
Name three of the features managed by the surface area configuration tool? : sql server security
What is service broker?
Can an entity have two primary keys?
Which are the important points to note when multilanguage data is stored in a table?
What is difference between group by and having?
Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s
Explain trigger and its types?
Tell me what is de-normalization and what are some of the examples of it?
What is compression - row-level and page-level compression?
What happens if you delete a table that is used by a view?
-
Oracle (3259) - 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)
