Answer Posted / 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 |
Post New Answer View All Answers
Explain what is scheduled job and how to create it?
What is difference between equi join and inner join?
What is nolock hint in sql server 2008
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What authentication modes does sql server support?
How you can get a list of all the table constraints in a database?
Do you know the different ddl commands in sql?
Why use “nolock” in sql server?
Tell me about normalization in DBMS.
Can another user execute your local temporary stored procedures?
How to generate random numbers with the rand() function in ms sql server?
What options are available to audit login activity? : sql server security
Explain few examples of stored procedure over triggers?
How many categories of data types used by sql server?
What is row_number()?