为什么临时表会无效(50分)

小

小田

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-03

• #1

declare @sqlstring nvarchar(3000)
if exists(select name from tempdb..sysobjects where name like '#aaa%')
drop table #aaa
set @sqlstring='select clid into #aaa from dbo.zl group by clid'
exec (@sqlstring)
select * from #aaa
请问：为什么#aaa临时表会无效的呢？

 

X

xiaoer

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-03

• #2

declare @sqlstring nvarchar(3000)
if exists(select name from tempdb..sysobjects where name like '#aaa%')
drop table #aaa
//set @sqlstring='select clid into #aaa from dbo.zl group by clid'
//exec (@sqlstring)
//上面两句换为直接运行！
select clid into #aaa from dbo.zl group by clid
select * from #aaa
注：本地临时表仅在当前会话中可见，并且将在退出其作用域时由系统自动除去。

 

小

小田

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-03

• #3

问题是一定要用exec啊，不然我问什么，呵呵

 

X

xiaoer

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-03

• #4

declare @sqlstring nvarchar(3000)
if exists(select name from tempdb..sysobjects where name like '#aaa%')
drop table #aaa
set @sqlstring='select clid into #aaa from dbo.zl group by clid' + char(13)+
'go '+char(13)+
'select * from #aaa'
exec (@sqlstring)

 

小

小田

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-03

• #5

那我怎么怎样使用#aaa呢：
.....
select * from #aaa...
......
我用#aaa表还要做个查询

 

小

小田

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-08

• #6

版主，回答无效，请还分,thanks!

 

Y

ylzxb123

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-07-25

• #7

可以写为
exec('select clid into #aaa from dbo.zl group by clid select * from #aaa')

 

Y

ycxy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-07-25

• #8

exec (@sqlstring+' select * from #aaa ')
exec中的临时表在exec结束后消失

 

小

小田

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-03-30

• #9

多人接受答案了。