What is the use of SCOPE_IDENTITY() function?
- 2 Answers
- 5500 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 is the difference between views and stored procedures? Can we have input parameters for views?
What is molap and its advantage? : sql server analysis services, ssas
Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?
Explain “not null constraint” in sql server?
wat is the main diff between sql server 2000and sql server 2005
can you any body tell me the difference between candidate key and primary key
What is the difference between windows authentication and sql server authentication
Can a table have 2 foreign keys?
What are the different types of queries?
What authentication modes does sql server support?
Why do we use stored procedures in sql server?
Write SQL queries on Self Join and Inner Join.
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
