Wednesday, May 7, 2008

Temporary Tables - MS SQL Server

Temporary Tables - MS SQL Server « Systems Engineering and RDBMS: "Temporary Tables - MS SQL Server"

Open one session in Query Analyzer or SSMS (Management Studio) and create a temporary table as shown below.
CREATE TABLE #TEMP
(
COL1 INT,
COL2 VARCHAR(30),
COL3 DATETIME DEFAULT GETDATE()
)GO

No comments: