SQLSERVER拆分逗号分隔的字段为多条数据

select
    a.ProjGuid,
    SUBSTRING(a.ZygwAllGUID,number,CHARINDEX(',',a.ZygwAllGUID+',',number)-number) as ZygwGUID,
    CjRoomTotal,
    QSDate 
from
   s_Contract as a,master..spt_values 
where
    number >=1 and number < len(a.ZygwAllGUID)  
    and type='p'
    and substring(','+a.ZygwAllGUID,number,1)=','

在这里插入图片描述

版权声明：本文为qq_25128693原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。