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'.