SQL SERVER 临时表

create procedure Proc_TestTempTable
as
begin

create table #t20170413
(
col_1 varchar(100) ,
col_2 varchar(100)
)

insert into #t20170413 values (‘aaa‘,‘bbb‘);

select * from #t20170413
--select * from tempdb.sys.tables where name like ‘#t20170413%‘
end

SQL SERVER 临时表

原文：https://www.cnblogs.com/hbsoft/p/14687986.html