给你看个查分的例子

if not object_id('Tab') is null
    drop table Tab
Go
Create table Tab([Col1] int,[COl2] nvarchar(5))
Insert Tab
select 1,N'a,b,c' union all
select 2,N'd,e' union all
select 3,N'f'
GO

--sql2005 或更高版本
SELECT  a.COl1 , Col2 = T.c.value('.' , 'nvarchar(100)')
FROM    (
         SELECT Col1 , Col2= CONVERT( XML, '<v>'+ REPLACE (COl2 , ',' , '</v><v>')+ '</v>') FROM Tab
        ) a
CROSS APPLY a.Col2.nodes('/v/text()') T (c)
/*
COl1    Col2
1    a
1    b
1    c
2    d
2    e
3    f
*/