SQL SERVER : Semuanya Lewat Script (2) – Create Temporary Table July 15, 2006Posted by sarach in SQL Server, Tips Programming, Visual Basic, Web Master.
Create a temporary table
Creating a temporary table is virtually the same as creating a normal table. The main exception is the naming of the table. A hash (‘#’) character as the first character in the table name denotes that it is a temporary table.There are two types of temporary tables, local and global.A local temporary table has a single hash (‘
#‘) at the start of its name. A local temporary table is visible only to the user who created it and is destroyed automatically when that user disconnects.A global temporary table is denoted by a name starting with two hashes (i.e. ‘
##‘). A global temporary table is visible to all users and is deleted automatically when the last user who has referenced the table disconnects.
An example of creating a local temporary table:
create table #foo
An example of creating a global temporary table:
create table ##baz