34,575
社区成员
发帖
与我相关
我的任务
分享
declare @t float
select @t = 206.26
select @t + ltrim('')
--206.25999999999999
declare @t float
select @t = 206.260695187175
select @t + ltrim('')
select convert(varchar,30206.260695187175111111)
------------------------------
30206.260695187175111111
(所影响的行数为 1 行)
declare @S float
set @S=30206.260695187175
select result=LOWER(@S)
还是没法
declare @S float
set @S=30206.260695187175
select convert(nvarchar(50),@S)
select cast(@S as nvarchar(50))
小数部分不能全部保留
declare @f float
set @f=1234.12311111166666
select ltrim(@f)
1234.12
select convert(nvarchar(50),1234.423)
select cast(1234.423 as nvarchar(50))
declare @f float
set @f=1234.123
select ltrim(@f)
/**
----------------------
1234.12
(所影响的行数为 1 行)
**/