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