22,209
社区成员
发帖
与我相关
我的任务
分享
IF 1=2
begin
SELECT * INTO #t FROM t1
DROP TABLE #t
end
IF 1=3
begin
SELECT * INTO #t FROM t1
DROP TABLE #t
end
declare @sql varchar(2000)
IF 1=2
begin
select @sql='SELECT * INTO #t FROM '+'t1'+';DROP TABLE #t'
end
IF 1=3
begin
select @sql='SELECT * INTO #t FROM '+'t1'+';DROP TABLE #t'
end
exec(@sql)
create table #T(col.....)
if ..
insert into #T...
else if
insert into #T ...