转:sqlserver 人民币数字转大写
摘要:
CREATE FUNCTION [dbo].[f_num_chn] (@num numeric(14,5)) 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 16:33 0101101 阅读(326) 评论(0) 推荐(0)
浙公网安备 33010602011771号