34,576
社区成员
发帖
与我相关
我的任务
分享
--測試##T
SELECT 1 AS ID INTO ##Tmp
--外部#T
CREATE TABLE #T(ID int)
declare @TempTable varchar(50)
set @TempTable = '##Tmp'
INSERT #T exec ('select * from ' + @TempTable)--傳到#T
SELECT * FROM #T
首先你得定义#T
再插入#T
create table #T()
declare @TempTable varchar(50)
set @TempTable = '##Tmp'
exec ('select * into #T from ' + @TempTable)
declare @TempTable varchar(50)
set @TempTable = '##Tmp'
exec ('select * into #T from ' + @TempTable)
declare @TempTable varchar(50)
set @TempTable = '##Tmp'
exec ('select * from ' + @TempTable)
exec ('insert into #T select * from ' + @TempTable)
exec ('select * into #T from ' + @TempTable)
exec ('select * into #T from ' + @TempTable)