sql

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

Subscribe to RSS - sql