Increment or decrement a column in SQL Server
Using SQL on SQL Server, it is easy to decrement or increment a column.
UPDATE t_test
SET inc = inc + 1,
dec = dec - 1
WHERE blah = blah
Using SQL on SQL Server, it is easy to decrement or increment a column.
UPDATE t_test
SET inc = inc + 1,
dec = dec - 1
WHERE blah = blah