sql Temporary Tables

CREATE TABLE #MyTempTable (
	TempID int,
	Name varchar(50)
)

INSERT INTO #MyTempTable (TempID,Name)
VALUES (1,'Testing')

SELECT * FROM #MyTempTable

DROP TABLE #MyTempTable
Syntax for creating a temporary table on the fly.

Updated: Saturday 9th October 2010, 00:31pm

There are 0 comments

Leave a comment of your own

Comments are currently closed.