Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mohammadali.info
Temporary tables are a useful tool in SQL Server provided to allow for short term use of data. There are two types of temporary table in SQL Server, local and global.
Local temporary tables are only available to the current connection to the database for the current user and are dropped when the connection is closed. Global temporary tables are available to any connection once created, and are dropped when the last connection using it is closed.
Both types of temporary tables are created in the system database tempdb.
Temporary tables can be created like any table in SQL Server with a CREATE TABLE or SELECT..INTO statement. To make the table a local temporary table, you simply prefix the name with a (#). To make the table a global temporary table, prefix it with (##).
-- Create a local temporary table using CREATE TABLE
CREATE TABLE #myTempTable
(
DummyField1 INT,
DummyField2 VARCHAR(20)
)
-- Create a local temporary table using SELECT..INTO
SELECT
age AS DummyField1,
lastname AS DummyField2
INTO #myTempTable
FROM DummyTable
To make these into global temporary tables, just replace (#) with (##)
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
Do you know what is similarity and difference between truncate and delete in sql?
What is the difference in accessing db between sql server vs sql azure?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Is a primary key unique?
What are the new scripting capabilities of ssms? : sql server management studio
explain declarative management framework (dmf) in sql server 2008?
What are indexes in ms sql server?
Where views are stored in sql server?
How do you set a trace flag in sql server?
is there a column to which a default can't be bound? : Sql server database administration
What is change data capture (cdc) in sql server 2008?
What is normalization? Describe its different types.
What is the bookmark lookup and rid lookup?
What is a join in sql?
What do you understand by integration services in sql server?
