也可以like如果字段中没有 "," select ............... ............... where ','+@参数+',' like '%,'+cast( yourfield as varchar(50) )+ ',%'
create proc chk @para nvarchar(1000) as begin declare @sql varchar(2000) set @sql='select * from test where fieldname in ('+@para+')' exec(@sql) end 然后在外面调用这个存储过程chk就可以了 exec chk '1,2'
select ...............
...............
where ','+@参数+',' like '%,'+cast( yourfield as varchar(50) )+ ',%'
as
begin
declare @sql varchar(2000)
set @sql='select * from test where fieldname in ('+@para+')'
exec(@sql)
end
然后在外面调用这个存储过程chk就可以了
exec chk '1,2'
字段是整形的,你这样写不是把它当作字符串了吗