USE [SPECIAL_BLD]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[get_upper]
(
@num numeric(18,5)
)
RETURNS VARCHAR(500)
AS
BEGIN
DECLARE @n_data VARCHAR(20),@c_data VARCHAR(100),@n_str VARCHAR(10),@i int
SET @n_data=https://www.cnblogs.com/ning-xiaowo/p/RIGHT(SPACE(14)+CAST(CAST(ABS(@num*100) AS bigint) AS varchar(20)),14)
SET @c_data=''
SET @i=1
WHILE @i<=14
BEGIN
SET @n_str=SUBSTRING(@n_data,@i,1)
IF @n_str<>' '
BEGIN
IF not ((SUBSTRING(@n_data,@i,2)='00') or
((@n_str='0') and ((@i=4) or (@i=8) or (@i=12) or (@i=14))))
SET @c_data=https://www.cnblogs.com/ning-xiaowo/p/@c_data+SUBSTRING('零壹貳叁肆伍陸柒捌玖',CAST(@n_str AS int)+1,1)
IF not ((@n_str='0') and (@i<>4) and (@i<>8) and (@i<>12))
SET @c_data=https://www.cnblogs.com/ning-xiaowo/p/@c_data+SUBSTRING('仟佰拾億仟佰拾萬仟佰拾圓角分',@i,1)
IF SUBSTRING(@c_data,LEN(@c_data)-1,2)='億萬'
SET @c_data=https://www.cnblogs.com/ning-xiaowo/p/SUBSTRING(@c_data,1,LEN(@c_data)-1)
END
SET @i=@i+1
END
IF @num<0
SET @c_data='https://www.cnblogs.com/ning-xiaowo/p/（負數）'+@c_data
IF @num=0
SET @c_data='https://www.cnblogs.com/ning-xiaowo/p/零圓'
IF @n_str='0'
SET @c_data=https://www.cnblogs.com/ning-xiaowo/p/@c_data+'整'
RETURN(@c_data)
END
GO
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/28305.html
標籤：SQL Server
上一篇：mssql sqlserver 如何撰寫case when 多條件呢?
下一篇：SQL多欄位的查詢重復記錄