Answer Posted / saravakumar
Returns the most recently created identity value for the
tables in the current execution scope.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are sql server procedures?
Does partitioning improve performance sql server?
What is the difference in accessing db between sql server vs sql azure?
How self join is different from outer join?
What is the difference between for auto and for nested?
What are the restraints imposed on the table design by a merge replication?
What is bit data type?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is the difference between count () and rowcount ()?
What do you mean by an execution plan? Why is it used? How would you view it?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What are subqueries in sql server?
Explain what is the difference between a local and a global temporary table?
Which database stores information about replication?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.