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 |
|
gpc44
Starting Member
35 Posts |
 Posted - 2011-11-28 : 10:34:27
|
Hello,The Merge command does indeed basically a Bulk-Insert/Update - by, or delete that which is performed either completely (commit) or not (rollback).Question: Is it possible that the data are plausible and which are inserted violate any Constaints, and those who violate the constrains on the sidelines - and be logged?It is naturally bitter, if the whole transaction fails, only because of 1000 records one record is not clean.Thank youBest RegardsNicole |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2011-11-28 : 12:26:06
|
| If I understand your question, NO. Merge adhears to the ACID properties and as such, it's all or nothing (transaction). |
 |
|
|
|
|
|
Merge