将字符串分割成多行:
DECLARE @xx NVARCHAR(500);
SET @xx='''c5222f69-858f-49d6-885e-6173c231c052'',''c85d8c39-b2a2-4c33-84cf-8e03b6354cb7'',''c85d8c39-b2a2-4c33-84cf-8e03b6354cb7''';
create table #list (name varchar(1000));
insert into #list (name ) VALUES(@xx);
select b.number,substring(a.name, b.number, charindex(',', a.name + ',', b.number) - b.number)
from #list a JOIN master..spt_values b on b.type = 'P'
where charindex(',', ',' + a.name, b.number) = b.number
--去掉前后空格
select b.number,REPLACE(SUBSTRING(a.id, b.number, CHARINDEX(',', a.id + ',', b.number) - b.number) ,'''','')
from #list a JOIN master..spt_values b on b.type = 'P'
where charindex(',', ',' + a.name, b.number) = b.number
DROP TABLE #list