SQL Server中文大写金额转化函数

概述SQL Server中文大写金额转化函数

下面是内存溢出 jb51.cc 通过网络收集整理的代码片段。

内存溢出小编现在分享给大家，也给大家做个参考。

CREATE FUNCTION usf_ChineseCost( @Cost float)RETURNS varchar(50)AS----大写钱数----BEGIN declare @returnStr varchar(50) if (@Cost >= 1000000000)    Begin  set @returnStr = '##########'        return @returnStr    end  set @returnStr = '00000000000' set @returnStr = right(@returnStr + convert(varchar,convert(decimal(11,2),round(@cost,2))),12) set @returnStr = replace(@returnStr,'0','零') set @returnStr = replace(@returnStr,'1','壹') set @returnStr = replace(@returnStr,'2','贰') set @returnStr = replace(@returnStr,'3','叁') set @returnStr = replace(@returnStr,'4','肆') set @returnStr = replace(@returnStr,'5','伍') set @returnStr = replace(@returnStr,'6','陆') set @returnStr = replace(@returnStr,'7','柒') set @returnStr = replace(@returnStr,'8','捌') set @returnStr = replace(@returnStr,'9','玖')           set @returnStr = @returnStr + '分' set @returnStr =  stuff(@returnStr,len(@returnStr)-1,'角') set @returnStr =  replace(@returnStr,'.','元') set @returnStr =  stuff(@returnStr,len(@returnStr)-5,'拾') set @returnStr =  stuff(@returnStr,len(@returnStr)-7,'百') set @returnStr =  stuff(@returnStr,len(@returnStr)-9,'千') set @returnStr =  stuff(@returnStr,len(@returnStr)-11,'万') set @returnStr =  stuff(@returnStr,len(@returnStr)-13,len(@returnStr)-15,len(@returnStr)-17,len(@returnStr)-19,'亿') set @returnStr =  replace(@returnStr,'零亿','零') set @returnStr =  replace(@returnStr,'零千','零百','零拾','零零零','零零','零万','万') set @returnStr =  replace(@returnStr,'零元','元') set @returnStr =  replace(@returnStr,'零角','零分','') while left(@returnStr,1) = '零'    Begin    set @returnStr =  right(@returnStr,len(@returnStr)-1)    end if ((left(@returnStr,1)='万'))  begin  set @returnStr =  right(@returnStr,len(@returnStr)-1) end if ((left(@returnStr,1)='元'))  begin  set @returnStr =  right(@returnStr,len(@returnStr)-1) end while left(@returnStr,len(@returnStr)-1)    end while right(@returnStr,1) = '零'    Begin    set @returnStr =  left(@returnStr,len(@returnStr)-1)    end set @returnStr =  replace(@returnStr,'亿万','亿零') set @returnStr =  replace(@returnStr,'零') if (@returnStr='')  begin  set @returnStr =  '零元' end if ((right(@returnStr,1)='元'))  begin  set @returnStr =  @returnStr + '整' end return @returnStrEND

以上是内存溢出(jb51.cc)为你收集整理的全部代码内容，希望文章能够帮你解决所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。

总结

以上是内存溢出为你收集整理的SQL Server中文大写金额转化函数全部内容，希望文章能够帮你解决SQL Server中文大写金额转化函数所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。