用一个参数
create proce 名
@参数 varchar(200)
as
exec ('select * from table1 where name in('+@参数+')')--------调用
exec 名 '"ad","tad","te"'
create proce 名
@参数 varchar(200)
as
exec ('select * from table1 where name in('+@参数+')')--------调用
exec 名 '"ad","tad","te"'
create procedure procedure_name
@ad int,
@tad int,
@te int
as
select ...
from ...
where 例如ad=@ad...测试:
use pubs
exec procedure_name 1,2,3分别传入1,2,3