How can we change 1 to 0 and 0 to 1 in a column of sql sever

Accepted answer

Try this:

select ~IsExpired from @ProductTotals

The operator ~ will flip the value of bit

https://stackoverflow.com/questions/171173/how-do-i-flip-a-bit-in-sql-server

+1

Hi Mayank youre query resolved ?

0

Hi Mayank,

IIF() in SQL 2012 does this functionality.

Did it resolved your problem ?

0

SQL 2012 has IIF().

Try this.

update ProductTotals
set IsExpired=IIF(IsExpired=0,1,0)

0

Use order by in your query

0

You can use ORDER BY.

SELECT * FROM @ProductTotals ORDER BY IsExpired

+3