declare @mysql varchar (1000)='create table #team1(a int); select * from #team1'
exec (@mysql) 

declare @mysql varchar (1000)='create table #team1(a int); select * from #team1'
exec (@mysql)
select * from #team1

/*
(0 row(s) affected)

(1 row(s) affected)
Msg 208, Level 16, State 0, Line 3
Invalid object name '#team1'.*/