Answer / 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 (##)

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

---

How to copy data from one table to another table?

0 Answers  

---

How many categories of data types used by sql server?

0 Answers  

---

How to automatically create a log when an exception is being received into SQL Server?

0 Answers   Cap Gemini,

---

How to insert data into an existing table?

0 Answers  

---

What is purpose of normalization?

0 Answers  

---

Explain what are sparse columns?

0 Answers  

---

What is the use of =,==,=== operators?

0 Answers  

---

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

28 Answers   IBM, Symphony,

---

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

---

what are triggers? : Sql server database administration

0 Answers  

---

user defined datatypes

1 Answers   Wipro,

---