float转varchar

  declare   @a   float  
  set   @a=2261400270130.0  
  --select   convert(decimal(20,1),@a)  
  select   convert(varchar(20),convert(decimal(20,1),@a))
原文地址:https://www.cnblogs.com/onlytiancai/p/1332045.html