Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • RE: split string and return as table column

    ---------------------------------

    -- Author: liangCK ??

    -- Date : 2008-11-14 19:03:48

    ---------------------------------

    --> ??????: #tb

    CREATE TABLE #tb(col VARCHAR(50))

    INSERT INTO #tb

    SELECT 'aa,bb,cc' UNION ALL

    SELECT 'AAA,BB' UNION ALL

    SELECT 'AAA'

    --SQL????:

    DECLARE @sql VARCHAR(8000)

    DECLARE @i INT,@m...

  • RE: split string and return as table column

    ---------------------------------

    -- Author: liangCK ??

    -- Date : 2008-11-17 17:00:09

    ---------------------------------

    --> ??????: [T]

    IF OBJECT_ID('[T]') IS NOT NULL DROP TABLE [T]

    CREATE TABLE [T] (col VARCHAR(50))

    INSERT INTO [T]

    SELECT 'aa,bb,cc' UNION ALL

    SELECT...

Viewing 2 posts - 1 through 3 (of 3 total)