sql 人民币数字转大写
摘要：
CREATE FUNCTION [dbo].[f_num_chn] (@num numeric(18,2)) RETURNS varchar(100) WITH ENCRYPTION AS BEGIN --版权所有：weihuachao@sina.com DECLARE @n_data VARCHAR(20),@c_data VARCHAR(100),@n_str VARCHAR(10),@i int SET @n_data=RIGHT(SPACE(14)+CAST(CAST(ABS(@num*100) AS bigint) AS varchar(20)),14) SET @c_data=&# 阅读全文
posted @ 2011-05-10 17:16 笑看风云淡 阅读(397) 评论(0) 推荐(0) 编辑
