Home Forums SQL Server 2008 SQL Server 2008 - General Update in all table RE: Update in all table
EamonSQL
SSCrazy
Points: 2307
More actions
October 24, 2012 at 6:28 am
#1552228
the MERGE statement might help you there but I would create separate update statements and run as a single transaction. Also use nested if statements so that if one update fails everything gets rolled back.
make sense?
Eamon