Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of SCOPE_IDENTITY() function?
- 2 Answers
- 6312 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / saravakumar
Returns the most recently created identity value for the
tables in the current execution scope.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / bhupesh
Returns the last identity value inserted into an identity
column in the same scope. A scope is a module: a stored
procedure, trigger, function, or batch.
| Is This Answer Correct ? | 3 Yes | 1 No |
What do you understand by user-defined function in the sql server?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
Can sql servers link to other servers like oracle?
How optimize sql query with multiple joins in sql server?
What is the purpose of self join?
What are different types of raid configurations? : SQL Server Architecture
What are the two virtual tables SQL Server maintains for triggers?
What is used to replicate sessions between instances in coldfusion clusters?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
If a stored procedure is taking a table data type, how it looks?
What is use of except clause? How does it differ from not in clause?
Can we insert data into 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)
