Example: use temporary tables in dynamic SQL

-- Define counters and dynamic SQL strings
Declare @ itcount Int = 0;
Declare @ strsql nvarchar (max) = NULL;

-- Create a temporary table
If object_id ('tempdb .. # mytable') is not null
Drop table # mytable

Create Table # mytable (strname nvarchar (50), strpass nvarchar (50 ));

-- Assign values to temporary tables cyclically
While @ itcount <100
Begin
Set @ itcount = @ itcount + 1;
Insert # mytable values ('str: '+ Cast (@ itcount as nvarchar), @ itcount );
End

-- Dynamically Execute SQL strings
Set @ strsql = 'select * from # mytable'
Execute (@ strsql );

Additional: currently, the test result is that table variables cannot be queried in dynamic SQL. Therefore, the temporary table is used as the processing container for temporary data.

If you have any suggestions, please submit them.