摘要: set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER FUNCTION [dbo].[fun_Str](@SourceSql varchar(8000),@StrSeprate varchar(10))RETURNS @temp TABLE(a varchar(100)) BEGIN DECLARE @i int SET @SourceSql=RTRIM(RTRIM(@SourceSql)) SET @i=charindex(@StrSeprate,@SourceSql) WHILE @i>=1 BEGIN ... 阅读全文
posted @ 2010-03-25 16:23 流浪者的飘 阅读(678) 评论(0) 推荐(0)
摘要: 1.去除数组重复的项 /// <summary> /// 去除SubSiteIds数组中重复的项 /// </summary> /// <param name="ArrInput"></param> /// <returns></returns> private string[] removeDuplicate(string[] ArrInput) { ArrayList nStr = new ArrayList(); for (int i = 0; i < ArrI... 阅读全文
posted @ 2010-03-25 14:01 流浪者的飘 阅读(300) 评论(0) 推荐(0)