Create Temp Table in T-SQL

CREATE TABLE #tblScratch
(
card int,
Name varchar(50),
Address varchar(50),
DateArrived datetime
) 

Insert into #tblScratch
(
card,
Name,
Address,
DateArrived
)
values (1,’John’,’Coit RD’,getdate()) 

Select * from #tblScratch