float转varchar declare @a float set @a=2261400270130.0 --select convert(decimal(20,1),@a) select convert(varchar(20),convert(decimal(20,1),@a))