SQL Server Transact Basic to Expert - Create a temporary table
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)