例如：在程序中，先编辑好了 string NameS=" ‘小明‘,‘小李‘,‘小黄‘ ";
调用存储过程
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[SP_PrcName] ( @NameS NVARCHAR(100) ) AS SET NOCOUNT ON EXEC( ‘SELECT*FROM T_tableName WHERE name IN (‘+@NameS+‘)‘ ) RETURN @@ERROR
即可查出结果
原文：http://www.cnblogs.com/oyer/p/5650863.html