Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of SCOPE_IDENTITY() function?
- 2 Answers
- 6502 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 |
How to list all field names in the result set using mssql_field_name()?
How do I completely remove sql server instance?
Explain what is the difference between union and union all?
What do you mean by cardinality?
What are the advantages of having an index on the sql server?
When columns are added to existing tables, what do they initially contain?
How to find 6th highest salary from Employee table ?
When would you prefer to have a minimum number of indexes?
what is trigger . hw will it use them
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is sql server agent and what are the two modes of authentication in sql server?
How to install sql server 2005 express edition?
-
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)
