这个存储过程为什么报错说变量没有声明 麻烦哪位看一下

[canidy]

create procedure tmp_cp as
declare @FromTableName varchar(20),
@ToTableName varchar(30)
declare Cur_Tab CURSOR for select [name] from sysobjects where type='u' and [name] like 'z_tab%' order by [name]
open Cur_tab
FETCH Cur_tab into @FromTableName
WHILE @@FETCH_STATUS=0
BEGIN
set @ToTableName='ygcwdb.dbo.'+ @FromTableName
INSERT INTO @ToTableName values (select * from @FromTableName)
FETCH Cur_tab into @FromTableName
END
CLOSE Cur_tab
DEALLOCATE Cur_tab
return
GO

[canidy]

这个存储过程我是想把一个库的表复制到另外一个库 因为用DTS导的过程出错了
报错行是insert into @ToTableName values (select * from @fromtablename)

[Softlee81307]

請把這句改成 insert into @ToTableName
select * from @fromtablename
再測試一下

[meilian01]

exec('insert into ' + @ToTableName +' values (select * from ' + ' @fromtablename ' + ')')

[jiang130]

同意樓上

[郭大侠_]

INSERT INTO @ToTableName values (select * from @FromTableName)
这个错了
不能用变量当表名
改为：
exec('insert into ' + @ToTableName +' values (select * from ' + ' @fromtablename ' + ')')