22,206
社区成员
发帖
与我相关
我的任务
分享
select b.KeyWords,a.ArticleId
from (select ArticleId,KeyWords=case when isnull(KeyWords,'') = '' then '卡车' else KeyWords end from [AC_Article]) a
cross apply (
select KeyWords=SUBSTRING(a.KeyWords,number,CHARINDEX(',',a.KeyWords+',',number+1)-number)
from master..spt_values
where CHARINDEX(',',','+a.KeyWords,number) = number AND type = 'P'
) b order by b.KeyWords
insert into Article_KeyWords_Relation
select KeyWords=SUBSTRING(b.KeyWords,number,CHARINDEX(',',b.KeyWords+',',number+1)-number),ArticleId
from master..spt_values a join Article b on a.number between 1 and LEN(b.KeyWords)
where CHARINDEX(',',','+b.KeyWords,number) = number AND type = 'P'
/*
KeyWords ArticleId
联合卡车 1
卡车 1
联合卡车 2
货车 2
东风 3
卡车 3
油车 3
联合卡车 4
搅拌车 4
自卸 4
轻卡 4
*/