22,209
社区成员
发帖
与我相关
我的任务
分享
UPDATE a
SET a.新列=b.NewCol
FROM information AS a
CROSS APPLY(SELECT ','+'word' FROM keyword WHERE a.描述 LIKE '%'+word+'%' FOR XML PATH('')) AS b(NewCol)
UPDATE a
SET a.新列=STUFF(b.NewCol,1,1,'')
FROM information AS a
CROSS APPLY(SELECT ','+部件 FROM keyword WHERE a.描述 LIKE '%'+部件+'%' FOR XML PATH('')) AS b(NewCol)
这样改UPDATE a
SET a.新列=b.NewCol
FROM information AS a
CROSS APPLY(SELECT ','+'word' FROM keyword WHERE a.描述 LIKE '%'+部件+'%' FOR XML PATH('')) AS b(NewCol)
UPDATE a
SET a.新列=b.NewCol
FROM information AS a
CROSS APPLY(SELECT ','+'word' FROM keyword WHERE a.描述 LIKE '%'+部件+'%' FOR XML PATH('')) AS b(NewCol)