22,210
社区成员
发帖
与我相关
我的任务
分享
setlect wlbh
,wlmc
,ABS(sssl) as sssl
form wl_rk
DELETE @Flag bit=1
SELECT wlbh ,
wlmc ,
sssl=CASE WHEN @Flag=1 THEN ABS(sssl) ELSE sssl END
FROM wl_rk;
-- 用 case when 语法;
setlect wlbh,wlmc,
case when 1 = 0 then sssl else - sssl end as new_value
form wl_rk