存储过程 给in怎么传参啊？

[yzy8788]

我现在存储过程中有一个in
我是这样做的

CREATE PROCEDURE QueryForRoom_Procedure
@hpWay varchar
 AS
begin 
select top 50 t.*,m.Integral,m.username from
(
	select * from 
	(
	  select top 50 * from shua_tasks where hpWay in (@hpWay) and isHidden='0' and status='1' order by ftime desc
	) t1

	union all

	select * from 
	(
	  select top 50 * from shua_tasks where hpWay in (@hpWay) and isHidden='0' and status<>'1' order by ftime desc
	) t2
) t left join shua_member m on t.fuserid=m.userid

end
GO

然后我调用存储过程的时候给@status传参'1,2,3,4'，但是发现执行处理的结果不对。
请先人指点哦~

[hao1hao2hao3]

里面的@hpWay 换成

 replace(''''+@hpWay +'''',',',''',''')

[水族杰纶]

select top 50 * 
from shua_tasks 
where charindex(','+ltrim(hpWay)+',',','+@hpWay+',')>0

[水族杰纶]

@hpWay varchar --这样要指定长度 否则 就一个长度字符

[yzy8788]

我这个字段hpWay 是int型的。

[bing0804]

CREATE PROCEDURE QueryForRoom_Procedure
@hpWay varchar
 AS
begin 

declare @sql varchar(4000)

set @sql='

select top 50 t.*,m.Integral,m.username from
(
    select * from 
    (
      select top 50 * from shua_tasks where hpWay in ('+ @hpWay +') and isHidden=''0'' and status=''1'' order by ftime desc
    ) t1

    union all

    select * from 
    (
      select top 50 * from shua_tasks where hpWay in ('+ @hpWay +') and isHidden=''0'' and status<>''1'' order by ftime desc
    ) t2
) t left join shua_member m on t.fuserid=m.userid'

exec(@sql)

end
GO

[lymmingv]

传进来的值要用字符串拼接。同5楼。