做的测试,只能exec来执行动态语句
declare @backupname varchar(20),@backuppath varchar(100),@sql varchar(300)
select @backupname='fff'
select @backuppath= 'E:\Microsoft SQL Server\MSSQL\BACKUP\fff.dat'
select @sql='execute sp_addumpdevice ''disk'','''+@backupname+''','''+@backuppath+''''
exec(@sql)
declare @backupname varchar(20),@backuppath varchar(100),@sql varchar(300)
select @backupname='fff'
select @backuppath= 'E:\Microsoft SQL Server\MSSQL\BACKUP\fff.dat'
select @sql='execute sp_addumpdevice ''disk'','''+@backupname+''','''+@backuppath+''''
exec(@sql)
好象就奇迹般的没错了
除了感谢还能说什么呢
declare @backupname varchar(1000),@backuppath varchar(1000)
select @backupname='fff'
select @backuppath= 'E:\Microsoft SQL Server\MSSQL\BACKUP\fff.dat'
execute sp_addumpdevice 'disk',@backupname,@backuppath/*--测试结果(所影响的行数为 1 行)'硬盘' 设备已添加。--*/