Using a Temporary Table to Communicate with an EXEC() : Temporary Table « Table « SQL Server / T-SQL Tutorial

7> CREATE TABLE #tmpvar
8> (
9>   Variable varchar (25) NOT NULL
10> )
11>
12> DECLARE
13>   @Variable varchar (25)
14>
15> EXEC ('INSERT INTO #tmpvar VALUES (''my value'')')
16>
17> SELECT
18>   @Variable = Variable
19> FROM
20>   #tmpvar
21>
22>
23> PRINT @Variable
24> GO

(1 rows affected)

(1 rows affected)
my value
1>
2> DROP TABLE #tmpvar
3> GO

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