Answer Posted / cow
scope identity will give you the last generated value for
the current session/scope. Note that @@identity is across
sessions.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what is a correlated sub-query? : Sql server database administration
What is resource governor in sql server?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
How to find which stored procedure is currently running in sql server?
Why I can not enter 0.001 second in date and time literals in ms sql server?
Does sql server 2000 full-text search support clustering?
Explain the Ways to improve the performance of a sql azure database?
Do you know what is fill factor and pad index?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What are the main sources of data?
What are the two authentication modes in sql server?
What is query cost in sql server?
What are the steps you should follow to start sql server in single-user mode?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What are the mathematical functions supported by sql server 2005?