SQL SERVER 临时表 使用 范例

declare @t nvarchar(1000)
set @t ='AA-00-DD-CC'-- newid()
set @t = newid();
set @t= replace(@t, '-', '_');
set @t = 'A'+@t
declare @s1 nvarchar(1000)
set @s1 = 'select * into ##' + @t+' from tbl_StockAllocated'
--exec (@s1);
EXEC sp_executesql @s1
set @s1 = 'select * from ##' + @t;
EXEC sp_executesql @s1

set @s1 = 'if object_id(''tempdb.##'+@t+''') is not null '+
    'drop table tempdb.'+@t;


print @s1
EXEC sp_executesql @s1