22,209
社区成员
发帖
与我相关
我的任务
分享
create table #db_temp1(ID int);
insert into #db_temp1 values (1)
insert into #db_temp1 values (2)
insert into #db_temp1 values (3)
DECLARE @temp1 nvarchar(20);
set @temp1='1,2';
select * from #db_temp1 where ID in (case when @temp1!='' then @temp1 else ID end);
create table #db_temp1(ID int);
insert into #db_temp1 values (1)
insert into #db_temp1 values (2)
insert into #db_temp1 values (3)
DECLARE @temp1 nvarchar(20)
DECLARE @SQL VARCHAR(1000)
set @temp1='1,2';
SET @SQL='select * from #db_temp1 where 1=1 '+
CASE WHEN ISNULL(@temp1,'')='' THEN '' ELSE 'AND ID in ('''+REPLACE(@temp1,',',''',''')+')' END
EXEC(@SQL)