I was required to update 40+ tables in our DB; Moran Benisty, our DBA master gave me a cool solution:
‘update ‘ + name + ‘ set SomeColumn = ”SomeValue” where OtherColumn = ”SomeOtherValueToMatchBy”’
name LIKE ‘LK_%’
Now all I had to do is copy the results and run them. Sweet !
BTW – use at your own risk. :)