摘要: 在指定字符中找到对应的英文大写信息CREATE function Get_StrArrayStrOfIndex(@str varchar(1024), --要分割的字符串@split varchar(10), --分隔符号@index int --取第几个元素)returns varchar(1024)asbegindeclare @location intdeclare @start intde... 阅读全文
posted @ 2009-07-06 15:23 马建康 阅读(1095) 评论(0) 推荐(0) 编辑
摘要: 1.--------------------------ALTER Function [dbo].[fn_LowerToUpperMoney](@num numeric(14,2)) RETURNS nvarchar(100) WITH ENCRYPTION AS BEGIN DECLARE @n_data nVARCHAR(20),@c_data nVARCHAR(100),@n_str... 阅读全文
posted @ 2009-07-06 11:09 马建康 阅读(1400) 评论(0) 推荐(0) 编辑
摘要: string[] arr1 = new string[4] {"", " THOUSAND", " MILLION", " BILLION"}; string[] arr2 = new string[10] {"ZERO", "TEN", "TWENTY", "THIRTY", "FORTY", "FIFTY", "SIXTY", "SEVENTY", "EIGHTY", "NINETY"}; s... 阅读全文
posted @ 2009-07-06 11:07 马建康 阅读(483) 评论(0) 推荐(0) 编辑