22,209
社区成员
发帖
与我相关
我的任务
分享
select * from [table] where [id] in ('1', '2')
ALTER PROCEDURE [dbo].[test_proc] @in -- in 里面的条件 形如:1,2,3
AS
BEGIN
DECLARE @sql VARCHAR(4000);
DECLARE @in2 VARCHAR(4000);
SET @sql = 'SELECT * FROM [table] where [id] in ('+@in2+')';
EXEC(@sql);
END
exec 'select * from [table] where [id] in (' + @1 + ', ' + @2 +')'
select * from [table] where [id] in (''@1'', ''@2'')