12 2011 档案

摘要:去除字符串前后的逗号:如:1,2,5, 变成 1,2,5,,,1,2,5, 变成 1,2,5,,,,,,, 变成View Code public String trim(String str) { int len = str.Length; int st = 0; char[] val = str.ToCharArray(); int i = 0; while ((st < len) && (val[st] <= ',')) { ... 阅读全文
posted @ 2011-12-28 17:15 宋佳莉 阅读(1649) 评论(2) 推荐(0)
摘要:View Code declare @str varchar(5000)set @str = ''select @str = @str + ' delete from ' + name from sysobjects where xtype = 'U' and name not like 'HZ%' and name not like 'H6_Coin' and name not like 'H6_Cost' and name not like 'H6_StoreHouse' and 阅读全文
posted @ 2011-12-08 08:44 宋佳莉 阅读(287) 评论(0) 推荐(0)