关于新建帐套，请看看下面的这个sql语句

[pearlz]

CREATE PROCEDURE back @dbold nchar(6),@dbnew nchar(6)
AS
Backup database @dbold
to disk='d:\gz\gz.bak'
RESTORE FILELISTONLY
FROM DISK ='d:\gz\gz.bak'
RESTORE DATABASE @dbnew
FROM DISK ='d:\gz\gz.bak'
WITH MOVE 'gz_data' TO 'c:\mssql7\data\gz05.mdf',
MOVE 'gz_log' TO 'c:\mssql7\data\gz05.ldf',
replace
delete from gz05..paycount where 月份<>11
update gz05..paycount set gz05..paycount.月份=1
这里的路经和数据库名gz05在pb里只能是常数吗，不能变量，自己设定吗

[tiantianpb]

用execute()

[pearlz]

我在pb中是这样写的
Declare ndzj procedure for @return=back @dbold=dbold1, @dbnew=dbnew1
using sqlca;

sqlca.autocommit=true
execute ndzj;
其中dbold1，dbnew1是变量，这样不行，但是改成常量就可以了

[tiantianpb]

加上：变量前

[tiantianpb]

Declare ndzj procedure for
ndjz @return=:back @dbold=:dbold1, @dbnew=:dbnew1
using sqlca;

sqlca.autocommit=true
execute ndzj;

[pearlz]

那么存储过程中的路径和数据库名呢，能不能改用变量

[tiantianpb]

当然可以用execute(@str_sqlexecute)