登 录
四舍五入加千分位
create function GetFormatString(@dec decimal(28,8), @n int)<br /> returns varchar(32) as<br /> begin<br /> declare @str varchar(32), @len int, @left varchar(32), @right varchar(32),@end varchar(32)<br /> if @n!='0'<br /> BEGIN<br /> set @str= round(@dec,@n)<br /> select @left=left(@str,charindex('.',@str)-1),@len=len(@left)-2<br /> while @len>1<br /> begin<br /> select @left=stuff(@left,@len,0,','), @len=@len-3<br /> end<br /> select @right=left(stuff(@str,1,charindex('.',@str),''), @n),@len=4<br /> while @len <=len(@right)<br /> begin<br /> select @right=stuff(@right,@len,0,','), @len=@len 4<br /> end<br /> set @end= @left '.' @right</p> <p>end<br /> else<br /> BEGIN<br /> set @str= round(@dec,@n)<br /> select @left=left(@str,charindex('.',@str)-1),@len=len(@left)-2<br /> while @len>1<br /> begin<br /> select @left=stuff(@left,@len,0,','), @len=@len-3<br /> end<br /> select @right=left(stuff(@str,1,charindex('.',@str),''), @n),@len=4<br /> while @len <=len(@right)<br /> begin<br /> select @right=stuff(@right,@len,0,','), @len=@len 4<br /> end<br /> set @end= @left<br /> end<br /> return @end<br /> end<br /> select dbo.GetFormatString(123645.7889, 2) '±' 'MON'<br /> union all select dbo.GetFormatString(123645.7889, 3) '±' 'MON'<br /> union all select dbo.GetFormatString(123645.7889, 4) '±' 'MON'<br />
抱歉!评论已关闭.