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
Please explain what is “asynchronous” communication in sql server service broker?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
Explain trigger and its types?
Write a sql query to delete duplicate records from a table called table1
How global temporary tables are represented and its scope?
what is sql server? : Sql server database administration
How to configure odbc dsn with different port numbers?
What are the different types of replication you can set up in sql server?
What is the data type of time?
How to enable tcp/ip protocol on a sql server?
What are recommended options to be used while using db mirroring? : sql server database administration
What is a transaction and why is it important?
how you can get the list of largest tables in a database? : Sql server administration
Is foreign key unique?
What are binary string data types in ms sql server?