#B
只限于当前查询,查询结束就过期,删除掉了用
declare @sql varchar(8000)
set @sql='select * into ##b from table2'
exec (@sql) select * from ##b
只限于当前查询,查询结束就过期,删除掉了用
declare @sql varchar(8000)
set @sql='select * into ##b from table2'
exec (@sql) select * from ##b
declare @sql varchar(8000)
set @sql='select * into #b from table2'
exec (@sql)
GO
select * from #b
set @sql='select * into #b from tb;select * from #b '
exec (@sql)
insert tb
select 1create table #b(col int)declare @sql varchar(8000)
set @sql='insert #b select col from tb'
exec (@sql)select * from #b
/*
col
-----------
1
*/
drop table tb,#b
declare @sql varchar(8000)
if (OBJECT_ID('tempdb..##b') >0 )
drop table ##bset @sql='select * into ##b from tb'
exec (@sql) select * from ##b 正确用法为 ,为全局临时表
declare @sql varchar(8000)
set @sql='select * into #b from table2;select * from #b'
exec (@sql)
--2.
declare @sql varchar(8000)
set @sql='select * into ##b from table2;'
exec (@sql)
select * from ##b
--3.
select * into #b from table2;
select * from #b