update tb set flag=(case when Flag=0 then 1 else then 0)
update tb set flag=abs(flag-1)
DECLARE @t TABLE ( EmpNo VARCHAR(100), Flag VARCHAR(100) ) INSERT @t SELECT 'XX','1' UNION ALL SELECT 'XX1', '0' UNION ALL SELECT 'xx2' , '1' UNION ALL SELECT 'XX3', '1' UNION ALL SELECT 'XX4', '0'SELECT * FROM @tUPDATE @t SET Flag= CASE Flag WHEN '1' THEN 0 WHEN '0' then '1' END SELECT * FROM @tEmpNo Flag ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- XX 1 XX1 0 xx2 1 XX3 1 XX4 0
掉了个end update tb set flag=(case when Flag=0 then 1 else then 0 end)
--flag是bit或是int型的用 update tb set flag=abs(flag-1) --flag是字符型的用 update tb set flag=(case when Flag=0 then 1 else then 0)
--flag是字符型的用 update tb set flag=(case when Flag='0' then '1' else then '0' end)
declare @t table(i bit) insert @t select 1 union all select 0 union all select 0update @t set i=1-i --或 update @t set i=abs(i-1)select * from @t i ---- 0 1 1(所影响的行数为 3 行)
set flag=(case when Flag=0 then 1 else then 0)
set flag=abs(flag-1)
DECLARE @t TABLE
(
EmpNo VARCHAR(100),
Flag VARCHAR(100)
) INSERT @t SELECT 'XX','1'
UNION ALL SELECT 'XX1', '0'
UNION ALL SELECT 'xx2' , '1'
UNION ALL SELECT 'XX3', '1'
UNION ALL SELECT 'XX4', '0'SELECT * FROM @tUPDATE @t SET Flag= CASE Flag WHEN '1' THEN 0 WHEN '0' then '1' END
SELECT * FROM @tEmpNo Flag
---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------
XX 1
XX1 0
xx2 1
XX3 1
XX4 0
update tb
set flag=(case when Flag=0 then 1 else then 0 end)
--flag是bit或是int型的用
update tb set flag=abs(flag-1)
--flag是字符型的用
update tb set flag=(case when Flag=0 then 1 else then 0)
--flag是字符型的用
update tb set flag=(case when Flag='0' then '1' else then '0' end)
insert @t select 1
union all select 0
union all select 0update @t set i=1-i --或 update @t set i=abs(i-1)select * from @t
i
----
0
1
1(所影响的行数为 3 行)
update @t set i=i-1刚测的.
结贴吧!顶下Tony和树人