create table XXX(A int,B int)insert XXX select 1,11 union all select 2,-12 union all select 3,13 union all select 4,-14 select A, case when SUBSTRING(convert(char(20),B),1,1) = '-' then SUBSTRING(convert(char(20),B),2,19) else B end as C from XXX-------------------------A C 1 11 2 12 3 13 4 14
update t set a = -1*a where a<0
update tb set col = abs(col) where col < 0update tb set col = 0 - col where col < 0
UPDATE TB SET COL=ABS(COL) WHERE COL<0
UPDATE TB SET COL=ABS(COL) WHERE COL<0 ABS()--返回指定数值表达式的绝对值(正值)的数学函数。--例如: SELECT ABS(-1.0), ABS(0.0), ABS(1.0)--结果集为: ---- ---- ---- --1.0 .0 1.0
UPDATE TB SET COL=ABS(COL) WHERE COL<0
UPDATE TB SET COL=ABS(COL) WHERE COL <0
使用绝对值,也可以update=-1*col where col<0
ABS()方法,取绝对值 UPDATE TB SET COL=ABS(COL) WHERE COL<0
select 1,11 union all
select 2,-12 union all
select 3,13 union all
select 4,-14 select
A,
case when SUBSTRING(convert(char(20),B),1,1) = '-'
then SUBSTRING(convert(char(20),B),2,19)
else B
end as C
from XXX-------------------------A C
1 11
2 12
3 13
4 14
ABS()--返回指定数值表达式的绝对值(正值)的数学函数。--例如:
SELECT ABS(-1.0), ABS(0.0), ABS(1.0)--结果集为:
---- ---- ----
--1.0 .0 1.0
UPDATE TB SET COL=ABS(COL) WHERE COL<0