怎样把数据库里一个bit字段的值取为相反的值

[bluefox168]

例如
假设该值为1我用update table set yesno=0
要是该值为0我则把他变为set yesno=1
用一条语句怎么实现?

[zjcxc]

update table set yesno=case yesno when 0 then 1 else 0 end

[zjcxc]

或者:
update table set yesno=yesno-1

[97866]

update table set yesno=ABS(yesno-1)

[txlicenhe]

update table set yesno=ABS(yesno-1)

[pengdali]

update 表 set 列=~列

[lionstar]

update yesno=not 取值

开心就好！！！

[JGTM2000]

hehe, so easy:

update table set yesno = 1 - yesno

To pengdali:

This works, but ONLY when column is of type "bit", because "~" does a BITWISE not operation. Everyone not using bit type column for storing boolean value should consider the 1-x expression instead.

[pengdali]

楼主不是说了是bit类型吗？

select ~cast(0 as bit)
select ~cast(1 as bit)

[bluefox168]

现在揭贴,只是分数太少了,各位前辈别介意