IF OBJECT_ID('fn_GetChnNum') IS NOT NULL
BEGIN
DROP FUNCTION dbo.fn_GetChnNum;
END;
GO
CREATE FUNCTION fn_GetChnNum ( @Number AS BIGINT )
RETURNS VARCHAR(100)
AS
BEGIN
DECLARE @ChnNum VARCHAR(100);
IF LEN(@Number) = 1
BEGIN
SET @ChnNum = SUBSTRING('零一二三四五六七八九', @Number + 1, 1);
END;
ELSE
BEGIN
DECLARE @Len INTEGER;
DECLARE @strNum AS VARCHAR(100);
DECLARE @i AS INTEGER;
DECLARE @NumWs AS INTEGER;
DECLARE @Unit AS VARCHAR(10);
SET @ChnNum = '';
SET @strNum = CAST(@Number AS VARCHAR(100));
SELECT @Len = LEN(@strNum);
SET @i = 1;
WHILE @i <= @Len
BEGIN
SET @Unit = '';
SET @NumWs = @L
用SQL将数字转换为中文数字
最新推荐文章于 2024-07-29 03:48:17 发布
这篇博客介绍了一个SQL自定义函数,用于将数字转换为中文数字表示。通过递归处理数字的每一位并结合不同数量级的中文单位,实现了数字的中文转换。最后给出了测试示例。
摘要由CSDN通过智能技术生成