Create Temporary Table T-SQL

DDL statement - create temporary table

To create a tmporary table you need to use create table command like in the below example.

Create Temporary Table

USE tempdb;
GO
CREATE TABLE #Course
(ID int,
Name varchar(255));
GO

Insert into Temporary Table

USE tempdb;
GO
insert into #Course(Id,Name)
values
(1,'SQL'),
(2,'Transact-SQL');
GO