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
Where do we use trace frag?
How to enter date and time literals in ms sql server?
How network traffic be reduced by using the stored procedure?
How to download and install microsoft sql server management studio express?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is the default fill factor value?
Explain trigger and trigger types?
What is the usage of the sign function?
What do you understand by SQL*Net?
State the difference between local and global temporary tables?
What are sql azure firewall rules?
How you can get a list of all the table constraints in a database? : Sql server administration
Where in ms sql server is ’100’ equal to ‘0’?
What is the use of “join” in sql server?
Explain what are the basic functions for master, msdb, model, tempdb databases?