CREATE FUNCTION dbo.f_digit_chn(@num bigint)
RETURNS varchar(20)
AS
BEGIN
--作者:pbsql
--@num为要转换为汉字字符串的整数,如123084转换为'壹贰叁零捌肆'
DECLARE @result varchar(20),@symbol varchar(2)
IF @num<0
SELECT @symbol='负',@result='',@num=ABS(@num)
ELSE
SELECT @symbol='',@result=''
WHILE @num<>0
SELECT @result=SUBSTRING('零壹贰叁肆伍陆柒捌玖拾',@num%10+1,1)+@result,@num=@num/10
RETURN @symbol+@result
END
GO
RETURNS varchar(20)
AS
BEGIN
--作者:pbsql
--@num为要转换为汉字字符串的整数,如123084转换为'壹贰叁零捌肆'
DECLARE @result varchar(20),@symbol varchar(2)
IF @num<0
SELECT @symbol='负',@result='',@num=ABS(@num)
ELSE
SELECT @symbol='',@result=''
WHILE @num<>0
SELECT @result=SUBSTRING('零壹贰叁肆伍陆柒捌玖拾',@num%10+1,1)+@result,@num=@num/10
RETURN @symbol+@result
END
GO