drop table #t1
select * into #t1 from sysusers
--go
drop table #t1
exec('select * into #t1 from sysusers')--这样可以,但是存在#t1临时表作用域的问题,在exec之外无法访问到。可以改成固定表或者全局临时表。
select * into #t1 from sysusers
--go
drop table #t1
exec('select * into #t1 from sysusers')--这样可以,但是存在#t1临时表作用域的问题,在exec之外无法访问到。可以改成固定表或者全局临时表。
select * into t11 from sysusers
drop table t11
select * into t11 from sysusers