如何转换类型？？

[crazycyber]

IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID(N'sp_ProdColorCount') AND OBJECTPROPERTY(ID,N'ISprocedure') = 1)
DROP procedure sp_ProdColorCount
go
create procedure sp_ProdColorCount
@prods varchar(500)--包括的机型
as
select * from sys_product where prod_id in (@prods)
go
execute sp_ProdColorCount '11,12'

服务器: 消息 245，级别 16，状态 1，过程 sp_ProdColorCount，行 4
将 varchar 值 '11,12' 转换为数据类型为 int 的列

由于prod_id是int的,select * from sys_product where prod_id in ('11,12')
这句语句就不能通过了.
改怎么解决这个问题呢?

[crazycyber]

问题顺利解决，想不到一个问题学到了这么多解法：）
多谢大家！！

[pengdali]

IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID(N'sp_ProdColorCount') AND OBJECTPROPERTY(ID,N'ISprocedure') = 1)
DROP procedure sp_ProdColorCount
go
create procedure sp_ProdColorCount
@prods varchar(500)--包括的机型
as
exec('select * from sys_product where prod_id in ('+@prods+')')
go
execute sp_ProdColorCount '11,12'

[Chiff]

create procedure sp_ProdColorCount
@prods varchar(500)--包括的机型
as
select * from sys_product where ','+@prods+',' like '%,' + prod_id + ',%'
go
execute sp_ProdColorCount '11,12'

--前提是：prod_id不包含逗号

[pengdali]

或：

IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID(N'sp_ProdColorCount') AND OBJECTPROPERTY(ID,N'ISprocedure') = 1)
DROP procedure sp_ProdColorCount
go
create procedure sp_ProdColorCount
@prods varchar(500)--包括的机型
as
select * from sys_product where ','+@prods+',' like ','+cast(prod_id as varchar(10))+','
go
execute sp_ProdColorCount '11,12'

[pengdali]

或：

IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID(N'sp_ProdColorCount') AND OBJECTPROPERTY(ID,N'ISprocedure') = 1)
DROP procedure sp_ProdColorCount
go
create procedure sp_ProdColorCount
@prods varchar(500)--包括的机型
as
select * from sys_product where charindex(','+cast(prod_id as varchar(10))+',',','+@prods+',')>0
go
execute sp_ProdColorCount '11,12'

[CrazyFor]

select * from sys_product where prod_id in (@prods)
改成:

select * from sys_product where charinde(','+cast(prod_id as varchar)+',' , ','+@prods+',')>0

[Chiff]

create procedure sp_ProdColorCount
@prods varchar(500)--包括的机型
as
select * from sys_product where ','+@prods+',' like '%,' + prod_id + ',%'