SQL Server Transact Basic to Expert - Create a temporary table

This blog shows how to create a temporary table in sql server

Syntax:

Create Table #TableName
(Column Name... Types... Null | NotNull)

Example:

CREATE TABLE #Empsal
( EmpID int NOT NULL PRIMARY KEY,
Empsal money NOT NULL,
Empcount int NOT NULL)