Article.upload LIKE '%' + CAST(Upload.id AS varchar(100)) + ',%') -->charindex(','+CAST(Upload.id AS varchar(100))+',' , ','+article.upload=',')>0
或
','+article.upload+',' like '%,'+ cast(upload.id as varhcar(100)) +',%'
或
','+article.upload+',' like '%,'+ cast(upload.id as varhcar(100)) +',%'
(SELECT Article.upload
FROM Article
WHERE ','+Article.upload+',' LIKE '%,' + CAST(Upload.id AS varchar(100)) + ',%') IS NULL
THEN '0' ELSE
(SELECT Article.upload
FROM Article
WHERE ','+Article.upload+',' LIKE '%,' + CAST(Upload.id AS varchar(100)) + ',%')
END AS number
FROM Upload
GROUP BY id
set @a='('select @a=@a+ltrim(rtrim(upload))+',' from Article
set @a=@a+')'set @sql='select id from upload where id not in replace('+@a+''',)'','')'')'
exec(@sql)
exec(@sql)