09 2013 档案

SQL CTE 递归分割以逗号分隔的字符串
摘要：declare @t table (id INT IDENTITY,sentence VARCHAR(2000))INSERT INTO @t SELECT 'AAA,BBB,CCC'SELECT * FROM @t ;WITH mycte AS ( SELECT id,sentence,mstart=1,mend=CHARINDEX(',',sentence)+1,num=1 FROM @t UNION ALL SELECT id,sentence,mstart=mend,CHARINDEX(',',sentence+',',m 阅读全文
posted @ 2013-09-18 17:24 第八颗流星 阅读(826) 评论(0) 推荐(0) 编辑