四舍五入加千分位

四舍五入加千分位

 

 create function GetFormatString(@dec decimal(28,8), @n int)returns varchar(32) asbegindeclare @str varchar(32), @len int, @left varchar(32), @right varchar(32),@end varchar(32)if @n!='0'BEGINset @str= round(@dec,@n)select @left=left(@str,charindex('.',@str)-1),@len=len(@left)-2while @len>1beginselect @left=stuff(@left,@len,0,','), @len=@len-3endselect @right=left(stuff(@str,1,charindex('.',@str),''), @n),@len=4while @len <=len(@right)beginselect @right=stuff(@right,@len,0,','), @len=@len 4endset @end= @left '.' @rightendelseBEGINset @str= round(@dec,@n)select @left=left(@str,charindex('.',@str)-1),@len=len(@left)-2while @len>1beginselect @left=stuff(@left,@len,0,','), @len=@len-3endselect @right=left(stuff(@str,1,charindex('.',@str),''), @n),@len=4while @len <=len(@right)beginselect @right=stuff(@right,@len,0,','), @len=@len 4endset @end= @leftendreturn @endendselect dbo.GetFormatString(123645.7889, 2) '±' 'MON'union all select dbo.GetFormatString(123645.7889, 3) '±' 'MON'union all select dbo.GetFormatString(123645.7889, 4) '±' 'MON'