Use # character in front of table name to create local temporary table
Example: Create temporary table #user
create table #user(id int, superiorid int)
insert into #user(id, superiorid)
values (1,null), (2,1) , (3,1)
drop table #user
Friday, November 22, 2013
Create Local temporary table in SQL Server
SQL Server > Temporary table > Create
Use # character in front of table name to create local temporary table
Example: Create temporary table #user
create table #user(id int, superiorid int)
insert into #user(id, superiorid)
values (1,null), (2,1) , (3,1)
drop table #user
Use # character in front of table name to create local temporary table
Example: Create temporary table #user
create table #user(id int, superiorid int)
insert into #user(id, superiorid)
values (1,null), (2,1) , (3,1)
drop table #user
