Increment or decrement a column in SQL Server
Submitted by jacob on Thu, 02/12/2009 - 4:02pmUsing 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
Topics:
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