一个查询问题，马上结贴

[niaoren]

我现在要写个存储过程，根据一个字段（ID)查询，但是有可能传进(1-N)个条件
如：select * form tablename where id =1 and id =8 and ......
怎样用存储过程实现呢？

[pengdali]

select * form tablename where id in (1,8,..)

[pengdali]

create proc xx
@a varchar(1000)
as
exec('select * from tablename where id in ('+@a+')')
go

exec xx '234,2342,234'

[zjcxc]

create proc p_test
@a varchar(8000)
as
exec('select * form tablename where id in('+@a+')')
go

[zjcxc]

--调用示例:

exec p_test '1,2,3'

[niaoren]

谢谢，结贴