Interested to Buy Any Domain ? << Click Here >> for more details...
What is SCOPE_IDENTITY() in sql
- 4 Answers
- 12012 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 |
How to delete duplicate rows?
Create and insert into temp table in sql server?
Can we insert data if clustered index is disabled?
Explain few of the new features of sql server 2008 management studio
What is triggers and its types?
Explain what is use of dbcc commands?
what is the basic diffrence betn a col declared in char(1) and in varchar(1)
What is function of CUBE ?
How to set the current database in ms sql server?
What the different topologies in which replication can be configured?
What are filegroups in sql server?
What are the restrictions that views have to follow? : SQL Server Architecture
-
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)
