博问 / 全部问题 / .NET技术 / C#

Code

        string A = "ac,abc,ac,ac,bc,bc";
        string[] temp = A.Split(',');
        List<string> t = new List<string>();
        foreach (string s in temp) {
            if (!t.Contains(s))
                t.Add(s);
        }
        string[] tStr = new string[t.Count];
        t.CopyTo(tStr);
        A = string.Join(',', tStr);

Sql Split
ALTER FUNCTION [dbo].[Split](@text nvarchar(4000), @splitChar char)
RETURNS @words TABLE (Word nvarchar(4000))
AS
BEGIN
    DECLARE @wordBegin smallint,
        @wordEnd smallint,
        @word nvarchar(4000)

    SELECT @wordBegin = 1

    WHILE @wordBegin <= LEN(@text)
    BEGIN
        SELECT @wordEnd = CHARINDEX(@splitChar, @text, @wordBegin) - 1
        IF(@wordEnd - @wordBegin < -1)-- not found, the last word
            BEGIN
              SELECT @word = LTRIM(RTRIM(SUBSTRING(@text, @wordBegin, LEN(@text) - @wordBegin + 1)));
              INSERT INTO @words(Word) VALUES(@word);
              BREAK
            END
        ELSE IF(@wordEnd - @wordBegin = -1)-- found ',', skip
            BEGIN
              SELECT @wordBegin = @wordEnd + 2
            END
        ELSE-- found
            BEGIN
              SELECT @word = LTRIM(RTRIM(SUBSTRING(@text, @wordBegin, @wordEnd - @wordBegin + 1)))
              INSERT INTO @words(Word) VALUES(@word)
              SELECT @wordBegin = @wordEnd + 2
            END
    END
        
    RETURN
END

ArrayDistinct
ALTER PROCEDURE dbo.ArrayDistinct(@Source varchar(255),@SplitChar char)
AS
BEGIN
SELECT * INTO #T FROM Split(@Source, @SplitChar)
SELECT DISTINCT * FROM #T
END

SAMPLE

CREATE TABLE #T(Index INT AUTO, Id INT, Ids VARCHAR(255));
SELECT Id, Ids INTO #T(Id, Ids) FROM T1;
DECLARE @Index INT, @Count INT, @Temp INT;
SELECT COUNT(Index) INTO @Count FROM #T;
CREATE TABLE #R(Id INT, Ids INT,  Kind INT);
SET @Index = 1;
WHILE(@Index <= @Count)
BEGIN
    SELECT Ids INTO @Temp FROM #T WHERE Index = @Index;
    SELECT @Index AS Id,  @Temp AS Ids, DISTINCT  Kind INTO #R(Id, Ids, Kind) FROM T2 WHERE Id IN(@Temp)
　  @Index ++;
END
SELECT * FROM #R -- return