pro_restore_database.sql

来自「一套宾馆管理系统」· SQL 代码 · 共 9 行

create procedure restoredatabase
@filename varchar(20)
as
declare @path varchar(300)
declare @PathAndName varchar(300) 
select @path=back_filepath from backupdevice a right outer join backupfilelist  b
on a.back_id=b.device_no where b.backup_name=@filename 
set @PathAndName=rtrim(@PathAndName)+'\'+rtrim(@filename)
restore database hotel from disk=@PathAndName with file=1