master_pro_restore_database.sql

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

create procedure RestoreDatabase 
@filename varchar(300) ,
@result varchar(30) output
as
declare @file varchar(30)
set @file=right(@filename,14)
restore database hotel from disk=@filename
if @@error<>0 --manager successfully
  begin
   insert into restorelist(backfile_id,retore_date,memo) select file_no,getdate(),'successfully' from backupfilelist where backup_name=@file
   set @result='成功恢复'
end
else --failure 
  begin
   set @result='恢复失败'
  end