34,837
社区成员




--用ROUND ( numeric_expression , length)函数
select convert(float,round(num,2)) from tab
select convert(float,round(x,2)) from t
select
case when
round(x,0)=x then
cast(round(x,0) as varchar(10)) else cast(round(x,2) as varchar(10)) end
from t
select
case when
CHARINDEX('.',cast(reverse(x) as varchar(50)),1)>3
then
CAST(x as decimal(9,2))
else x end
from t
select
case when
CHARINDEX('.',cast(reverse(x) as varchar(50)),1)>3
then
LEFT(CAST(x as varchar(50)),CHARINDEX('.',cast(x as varchar(50)),1)+2)
else x end
from t