sqlserver 存储过程中传参数问题

[CYSONG168]

我写的存储过程中

alter PROCEDURE pro_A(@str varchar(8000))
as
begin
declare @strtem varchar(8000)
set @strtem = @str
select * from ABCCode where ABCCode in (@strtem)
end



---exec pro_A '''A'',''B'''


执行过程没有结果呢？ 帮忙啊 谢谢！

[CYSONG168]

写法挺怪异，但是好用。

[Quote=引用 3 楼 acherat 的回复:]
SQL code

alter PROCEDURE pro_A(@str varchar(8000))
as
begin
declare @strtem varchar(8000)
set @strtem = @str
select * from ABCCode where charindex(','+ABCCode+',',','+@strtem+',') > 0
e……
[/Quote]

[AcHerat]

alter PROCEDURE pro_A(@str varchar(8000))
as 
begin
  declare @strtem varchar(8000)
  set @strtem = @str
 select * from ABCCode where charindex(','+ABCCode+',',','+@strtem+',') > 0
end

[快溜]

alter PROCEDURE pro_A(@str varchar(8000))
as  
begin
 select * from ABCCode where charindex(ABCCode+',',@str+',')>0
end



exec pro_A 'A,B'

[AcHerat]

alter PROCEDURE pro_A(@str varchar(8000))
as 
begin
  declare @strtem varchar(8000)
  set @strtem = @str
 select * from ABCCode where charindex(','+ABCCode+',',','+@strtem+',') > 0
end

exec pro_A  'A,B'

[王向飞]

select * from ABCCode where ABCCode in (@strtem)
那是因为没有检索到符合条件的记录

[--小F--]

alter PROCEDURE pro_A(@str varchar(8000))
as 
begin
  declare @strtem varchar(8000)
  set @strtem = @str
 select * from ABCCode where ','+@strtem+',' like %','+ABCCode+','% end

[gw6328]

alter PROCEDURE pro_A(@str varchar(8000))
as  
begin
  declare @strtem varchar(8000)
  set @strtem = @str
  EXEC('select * from ABCCode where ABCCode in ('+@strtem+')');
end

[风驰天下丨]

怎么我运行这SQL时，怎么出现下面的错误呢

消息 217，级别 16，状态 1，过程 pro_A，第 11 行
超出了存储过程、函数、触发器或视图的最大嵌套层数(最大层数为 32)。