declare @data float set @data=17.842323 select substring(cast(@data as nvarchar(10)),1 ,charindex('.',cast(@data as nvarchar(10)))+1 )
select cast(floor(17.858*10)/10 as dec(18,1)) as num num -------------------- 17.8(所影响的行数为 1 行)select cast(floor(17.858*100)/100 as dec(18,2)) as numnum -------------------- 17.85(所影响的行数为 1 行)
select cast(floor(18.8577 * 10)/10.0 as decimal(18,1))
/*
--------------------
18.8(所影响的行数为 1 行)
*/--两位
select cast(floor(18.8577 * 100)/100.0 as decimal(18,2))
/*
--------------------
18.85(所影响的行数为 1 行)
*/
set @data=17.842323
select substring(cast(@data as nvarchar(10)),1 ,charindex('.',cast(@data as nvarchar(10)))+1 )
num
--------------------
17.8(所影响的行数为 1 行)select cast(floor(17.858*100)/100 as dec(18,2)) as numnum
--------------------
17.85(所影响的行数为 1 行)