请教一个简单的存储故过程问题

[城一直在]

CREATE PROCEDURE test

as

set nocount on

declare @sql  nvarchar(200)

declare @table varchar(50)

set @table = 'tab1'

set @sql = 'select * into #TTT from '+@table

exec (@sql )

select * from #TTT

GO

请问我这个错在哪里了? 在ASP调用失败

[SinGooCMS]

在查询分析器里运行一下就知道了

[nzperfect]

set @sql = 'select * into #TTT from '+@table
-->
set @sql = 'select * into #TTT from '+@table +'; select * from #TTT'

[bwu851]

没把@table变量传进去?

[bwu851]

[Quote=引用 3 楼 bwu851 的回复:]
没把@table变量传进去?
[/Quote]

sorry, 看错了.

同意二楼的.

[wgzaaa]

set @sql = 'select * into ##TTT from '+@table

exec (@sql )

select * from ##TTT

[wgzaaa]

--昨天在这种题上就吃亏了,或者
set @sql = 'select * into #TTT from '+@table+' select * from #TTT'

exec (@sql )

go

[hyde100]

[Quote=引用 2 楼 perfectaction 的回复:]
SQL codeset @sql = 'select * into #TTT from '+@table
-->
set @sql = 'select * into #TTT from '+@table +'; select * from #TTT'
[/Quote]

---------------------------------------
以上，楼主的#TTT 已经过了引用范围

[wgzaaa]

--如果表名要作参数可改为
alter PROCEDURE test1 @table varchar(50) as
set nocount on
declare @sql nvarchar(200)
set @sql ='select * into #TTT from '+@table+' select * from #TTT'
exec (@sql)
GO
exec test1 'tab1'

[城一直在]

select * from ##TTT

上面两个#是什么意思？？？？

[nzperfect]

[Quote=引用 9 楼 msgame 的回复:]
select * from ##TTT

上面两个#是什么意思？？？？
[/Quote]
两##是全局临时表。

[城一直在]

感谢 perfectaction

[dsp_zerg]

系统临时表 (global)
一个#的是局部临时表 (local)