做汇总表
declare @number floatset @number=113431111.23
select CONVERT(varchar,@number)select @number
(无列名)1.13431e+008
113431111.23
指定一下varchar长度select CONVERT(varchar(20),@number)
SELECT CONVERT(NVARCHAR(50),CONVERT(DECIMAL(18,8),@number))