create table ##t1 (id int);
declare @str1 nvarchar(100);
set @str1 = 'insert into ##t1 values (1)';
execute sp_executesql @str1
select * from ##t1
(1 row(s) affected)
id
-----------
1
(1 row(s) affected)
create table #t2 (id int);
declare @str2 nvarchar(100);
set @str2 = 'insert into #t2 values (2)';
execute sp_executesql @str2
select * from #t2
(1 row(s) affected)
id
-----------
2
(1 row(s) affected)
==============================
declare @str1 nvarchar(100);
set @str1 = 'create table ##t1 (id
int);insert into ##t1 values (1)';
execute sp_executesql @str1
select * from ##t1
(1 row(s) affected)
id
-----------
1
(1 row(s) affected)
create table #t2 (id int);
declare @str2 nvarchar(100);
set @str2 = 'insert into #t2 values (2)';
execute sp_executesql @str2
select * from #t2
(1 row(s) affected)
Msg 208, Level 16, State 0,
Line 14
Invalid object name '#t2'.
