我爱Aspx >> 数据库 >> 小写转大写金额WHEN @#.@# THEN @#元@#
WHEN @#0@# THEN @#零@#
WHEN @#1@# THEN @#壹@#
WHEN @#2@# THEN @#贰@#
WHEN @#3@# THEN @#叁@#
WHEN @#4@# THEN @#肆@#
WHEN @#5@# THEN @#伍@#
WHEN @#6@# THEN @#陆@#
WHEN @#7@# THEN @#柒@#
WHEN @#8@# THEN @#捌@#
WHEN @#9@# THEN @#玖@#
END
+
case @i_I
WHEN 1 THEN @#分@#
WHEN 2 THEN @#角@#
WHEN 3 THEN @#@#
WHEN 4 THEN @#@#
WHEN 5 THEN @#拾@#
WHEN 6 THEN @#佰@#
WHEN 7 THEN @#仟@#
WHEN 8 THEN @#万@#
WHEN 9 THEN @#拾@#
WHEN 10 THEN @#佰@#
WHEN 11 THEN @#仟@#
WHEN 12 THEN @#亿@#
WHEN 13 THEN @#拾@#
WHEN 14 THEN @#佰@#
WHEN 15 THEN @#仟@#
WHEN 16 THEN @#万@#
ELSE @#@#
END
set @v_UpperStr = @v_UpperPart + @v_UpperStr
set @i_I = @i_I + 1
【我对这篇文章有话说?】
Google的技术剖析:创始人Sergey..[05-22]
实用的存储过程之二[05-22]
一道褒贬不一的 SQL 考试题[05-22]
PFC的使用与探索(一)[05-22]
如何将全文检索中的“干扰词”去..[05-22]
深入研究SQL结构化查询语言中的L..[05-22]
CREATE TABLE – SQL Command[05-22]
Fetching Across Commits: Where..[05-22]
动态的连接到数据库的方法[05-22]
锁定某一列实现同Excel中的样式[05-22]