SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table YourTable(Id int identity(1,1),Col1 varchar(100));

insert into YourTable(Col1)
values('Stack'),('Over'),('Flow')

3 rows affected

Declare @SqlStr varchar(max)

create table #TempTable(Id int identity(1,1),Col1 varchar(100))
set @SqlStr='Insert into #TempTable(Col1) select Col1 from YourTable'
exec(@SqlStr)
select * from  #TempTable


Id
Col1


1
Stack

2
Over

3
Flow


Declare @SqlStr varchar(max)
set @SqlStr='select * into  #TempTable1 from YourTable'
exec(@SqlStr)
select * from  #TempTable1
Msg 208 Level 16 State 0 Line 4
Invalid object name '#TempTable1'.