create function changebigsmall
(@changemoney money)
returns varchar(100) as
begin
declare @string1 char(20)
declare @string2 char(30)
declare @string4 varchar(100)
declare @string3 varchar(100) --从原a值中取出的值
declare @i int --循环变量
declare @j int --a的值乘以100的字符串长度
declare @ch1 varchar(100) --数字的汉语读法
declare @ch2 varchar(100) --数字位的汉字读法
declare @zero int --用来计算连续有几个零
declare @returnvalue varchar(100)
select @returnvalue = ''
select @string1 = '零壹贰叁肆伍陆柒捌玖'
select @string2 = '万仟佰拾亿仟佰拾万仟佰拾元角分'
select @string4 = cast(@changemoney*100 as int)
select @j=len(cast((@changemoney*100) as int))
select @string2=right(@string2,@j)
select @i = 1
while @i select @string3 = substring(@string4,@i,1)
if @string3'0' begin
select @ch1 = substring(@string1, cast(@string3 as int) 1, 1)
select @ch2 = substring(@string2, @i, 1)
select @zero = 0 --表示本位不为零
end
else begin
if (@zero = 0) or (@i = @j - 9) or (@i = @j - 5) or (@i = @j - 1)
select @ch1 = '零'
else
select @ch1 = ''
select @zero = @zero 1 --表示本位为0
--如果转换的数值需要扩大，那么需改动以下表达式 i 的值。
select @ch2 = ''
if @i = @j - 10 begin
select @ch2 = '亿'
select @zero = 0
end
if @i = @j - 6 begin
http://www.bkjia.com/phpjc/631145.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/631145.htmltecharticlecreate function changebigsmall (@changemoney money) returns varchar(100) as begin declare @string1 char(20) declare @string2 char(30) declare @string4 varchar(100) declare @string3...