CREATE FUNCTION [dbo].[GetChineseAmount] (@Money money)
RETURNS varchar(255)
AS
begin
DECLARE @Source varchar(255), @Temp nvarchar(2), @Unit nchar(1)
DECLARE @Segment1 varchar(255), @Segment2 varchar(255), @Result1 nvarchar(255), @Result2 nvarchar(255)
DECLARE @Length tinyint, @i tinyint, @x tinyint
DECLARE @List table(ID int identity(1,1), Item nchar(1))
-- 参数检查
IF @Money IS NULL
RETURN NULL
IF @Money = 0
RETURN '零'
-- 填充表
INSERT INTO @List (Item) VALUES ('壹')
INSERT INTO @List (Item) VALUES ('贰')
INSERT INTO @List (Item) VALUES ('叁')
INSERT INTO @List (Item) VALUES ('肆')
INSERT INTO @List (Item) VALUES ('伍')
INSERT INTO @List (Item) VALUES ('陆')
INSERT INTO @List (Item) VALUES ('柒')
INSERT INTO @List (Item) VALUES ('捌')
INSERT INTO @List (Item) VALUES (
将阿拉伯数字(1234)钱化为中国数字钱(壹贰叁肆)
最新推荐文章于 2021-09-08 22:30:36 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)