3 ms·
My practise is to do: UPDATE ImportantTable SET ImportantColumn = ImportantColumn WHERE Condition = True Check the rows affected, then change it to:
by lysp 10y ago
My practise is to do:
UPDATE ImportantTable SET
ImportantColumn = ImportantColumn
WHERE Condition = True
Check the rows affected, then change it to:
UPDATE ImportantTable SET
ImportantColumn = NewValue
WHERE Condition = True