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

最新推荐文章于 2021-01-28 08:20:40 发布

VIP文章 learningaginlearnin

最新推荐文章于 2021-01-28 08:20:40 发布

阅读量1.1k

点赞数

文章标签： sql server function float

本文链接：https://blog.csdn.net/learningaginlearnin/article/details/6572029

版权

 
   CREATE FUNCTION usf_ChineseCost 
  
    02
    ( 
   
    03
     @Cost float
   
    04
    ) 
   
    05
    RETURNS varchar(50) 
   
    06
    AS
   
    07
    ----大写钱数---- 
   
    08
    BEGIN
   
    09
     declare @returnStr varchar(50) 
   
    10
     if (@Cost >= 1000000000) 
   
    11
        Begin
   
    12
      set @returnStr = '##########'
   
    13
            return @returnStr 
   
    14
        end 
   
    15
     set @returnStr = '00000000000'
   
    16
     set @returnStr = right(@returnStr + convert(varchar,convert(decimal(11,2),round(@cost,2))),12) 
   
    17
     set @returnStr = replace(@returnStr,'0','零') 
   
    18
     set @returnStr = replace(@returnStr,'1','壹') 
   
    19
     set @returnStr = replace(@returnStr,'2','贰') 
   
    20
     set @returnStr = replace