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
What is blocking?
What is the use of custom fields in report?
How do I find the sql server database version?
A trigger can reference objects outside the current database? State true or false.
How to use copy and concatenate commands in SQL?
How you would rewrite the sql query to return the customerid sorted numerically?
What is row_number () and partition by in sql server?
What is the report model project?
What is sql server database?
What is the difference between primary key and unique constraints?
What is global temp table?
Tell me what are the advantages of using stored procedures?
How can you append an identity column to a temporary table?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Tell me what is a linked server?