SQL Server Merge statement issue
- by George2
Hello everyone,
I am learning and using SQL Server 2008 new Merge statement, merge statement will compare/operate source table and destination table row by row ("operate" I mean operations performed for when matched or not-matched conditions). My question is whether the whole merge process will be one transaction or each row comparison/operation will be one transaction?
Appreciate if any document to prove it.
thanks in advance,
George