SQL Table種類

Local Temporary Tables #TempTable
Global Temporary Tables ##TempTable
Permanent Tables TableName
Table Variables @TempTable

CREATE TABLE #TempTable
(
id INT,
name VARCHAR(32)
)

CREATE TABLE ##TempTable
(
id INT,
name VARCHAR(32)
)

CREATE TABLE TableName
(
id INT,
name VARCHAR(32)
)

DECLARE @TempTableTABLE
(
id INT,
name VARCHAR(32)
)