05 2011 档案

SQL SPLIT() 方法实现
摘要：ALTERfunction[dbo].[Fun_Split](@cvarchar(2000),@splitvarchar(2))returns@ttable(colvarchar(20))asbeginwhile(charindex(@split,@c)<>0)begininsert@t(col)values(substring(@c,1,charindex(@split,@c)-1))set@c=stuff(@c,1,charindex(@split,@c),'')endinsert@t(col)values(@c)returnend 阅读全文
posted @ 2011-05-23 17:27 melody&amp;amp;amp;bobo 阅读(216) 评论(0) 推荐(0)
JS获取URL参数值
摘要：方法1 functiongetUrlParam(name){varreg=newRegExp("(^|&)"+name+"=([^&]*)(&|$)");varr=window.location.search.substr(1).match(reg);if(r!=null)returnunescape(r[2]);returnnull;}方法2 functionrequest(paras){varurl=location.href;varparaString=url.substring(url.indexOf("?&qu 阅读全文
posted @ 2011-05-21 22:13 melody&amp;amp;amp;bobo 阅读(1237) 评论(0) 推荐(0)