Temporary Table in SQL Server

Question

How can i make temporary tables in SQL?

Shivanand Arur · Answer

CREATE TABLE #tmp -- tmp is the Table Name ( param1 int, param2 varchar(20) ) To create a temporary table, use the " # " and then the table name... But with this, the tmp table will be destroyed once the session is complete... Instead you can create a Global Temporary Table like this... CREATE TABLE ##tmp ( param1 int, param2 varchar(20) ) For More Reference... Check out these articles.. http://www.sqldbadiaries.com/2011/01/07/sql-server-does-not-start-fcbopen-operating-system-error-3the-system-cannot-find-the-path-specified/ http://blog.sqlauthority.com/2007/10/31/sql-server-importance-of-master-database-for-sql-server-startup/ http://stackoverflow.com/questions/3498256/physical-database-and-log-file-location http://www.trainsignal.com/blog/understanding-microsoft-sql-server-2005-system-databases http://programming4.us/database/1970.aspx Thank you.

Pradip Pandey · Answer

Hi Creating a temporary table in SQL is very simple and you can create 2 types of temporary tables.Here is the example for creating a local temporary table in SQL IF EXISTS ( SELECT * FROM tempdb.dbo.sysobjects WHERE ID = OBJECT_ID(N'tempdb..#TempTable') ) BEGIN DROP TABLE TempTable END CREATE TABLE #TempTable ( ChapterID int ,ChapterTitle varchar(255) ) GO For Creating a global temporary table use ## sign in place of #. Hope it will help.

Temporary Table in SQL Server

Answers (2)