Local temporary Table : Temporary Table « Table « SQL Server / T-SQL Tutorial

2> CREATE TABLE #config_out
3> (
4>     name_col    varchar(50),
5>     minval      int,
6>     maxval      int,
7>     configval   int,
8>     runval      int
9> )
10>
11> INSERT #config_out
12>     EXEC sp_configure
13>
14> SELECT * FROM #config_out
15> GO

(15 rows affected)
name_col                                           minval      maxval      configval   runval
-------------------------------------------------- ----------- ----------- ----------- -----------
allow updates                                                0           1           1           0
clr enabled                                                  0           1           0           0
cross db ownership chaining                                  0           1           0           0
default language                                             0        9999           0           0
max text repl size (B)                                       0  2147483647       65536       65536
nested triggers                                              0           1           1           1
remote access                                                0           1           1           1
remote admin connections                                     0           1           0           0
remote login timeout (s)                                     0  2147483647          20          20
remote proc trans                                            0           1           0           0
remote query timeout (s)                                     0  2147483647         600         600
server trigger recursion                                     0           1           1           1
show advanced options                                        0           1           0           0
user instances enabled                                       0           1           1           1
user options                                                 0       32767           0           0

(15 rows affected)

3.7.Temporary Table
	3.7.1.	Temporary Tables
	3.7.2.	Local temporary Table
	3.7.3.	Using a Temporary Table to Communicate with an EXEC()
	3.7.4.	A script that creates a global temporary table of random numbers
	3.7.5.	A script that uses a local temporary table instead of a derived table
	3.7.6.	SELECT INTO a temporary table
	3.7.7.	Creating a Table with Duplicate Rows
	3.7.8.	A global temporary table's name begins with ##.
	3.7.9.	Creating a Local Temporary Table with a SELECT INTO