declare @a float set @a = 234234 select cast(@a as varchar(20)),@a
declare @a numeric(12,2) set @a = 234234.00 select cast(@a as varchar(20)),@adeclare @b float(5) set @b = 234234.00 select cast(cast(@b as decimal(12,2)) as varchar(20)),cast( @b as varchar(20)),@b/*
set @a = 234234
select cast(@a as varchar(20)),@a
set @a = 234234.00
select cast(@a as varchar(20)),@adeclare @b float(5)
set @b = 234234.00
select cast(cast(@b as decimal(12,2)) as varchar(20)),cast( @b as varchar(20)),@b/*
-------------------- --------------
234234.00 234234.00(所影响的行数为 1 行)
-------------------- -------------------- ------------------------
234234.00 234234 234234.0(所影响的行数为 1 行)
*/
select convert(varchar(20),浮点数)
declare @f float,@s varchar(10)
set @f=12.987
set @s='|'+cast(@f as varchar) + '|'
select @s