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

What have included columns when we talk about sql server indexing?

1016

---

What is the filtered index?

1026

---

Does sql server 2016 have ssms?

940

---

What are the dmvs? : sql server database administration

1043

---

What are the differences between char and varchar in ms sql server?

1043

---

Can I disable or restrict ssrs export formats (rendering formats)?

148

---

What samples and sample databases are provided by microsoft?

1025

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1058

---

How to use transact-sql statements to access the database engine?

1042

---

What is sleeping status in sql server?

1013

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1008

---

How to write a query with an inner join in ms sql server?

1023

---

Explain the microsoft sql server delete command?

999

---

How are the unique and primary key constraints different?

1046

---

Write down the syntax and an example for create, rename and delete index?

960

---