Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Delinda
Constraint Violating Yak Guru
315 Posts |
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-04 : 04:04:50
|
The author is trying to say that if you insert 10 rows in a table, the Scope_Identity will return only the last inserted identity value(which he implies as single row processing) but there will be cases where you will want to get all the identity values of the 10 rows inserted.So a substitution for this will be using an OUTPUT clause.PBUH |
|
|
Delinda
Constraint Violating Yak Guru
315 Posts |
Posted - 2010-12-04 : 13:18:19
|
tq sir |
|
|
|
|
|