怎样在存储过程中用关键字IN？

Question

CREATE PROCEDURE ArticleDelete(@ArticleIdStr varchar(100))
AS
exec('DELETE  Article WHERE ArticleId IN ('+@ArticleIdStr+')')

Answer 1

CREATE PROCEDURE ArticleDelete(@ArticleIdStr varchar(100))
AS
DELETE  Article WHERE @ArticleIdStr like '%,'+cast(ArticleId as varchar(10))+',%'
go
---------------
exec ArticleDelete ',23,24,25,'

Answer 2

CREATE PROCEDURE ArticleDelete(@ArticleIdStr varchar(100))
AS
exec('DELETE  Article WHERE ArticleId IN ('+@ArticleIdStr+')')

Answer 3

you need using Dynamic SQL.
http://www.algonet.se/~sommar/dynamic_sql.html