CODE EXAMPLE FOR SQL

create temporary table sql

declare @table table (id int)
create table #table (id int)
create table ##table (id int)
select * into #table from xyz