select @backupSetId = position from msdb..backupset where database_name=N''CRIOnlineChatRoom'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''CRIOnlineChatRoom'' )
if @backupSetId is null begin raiserror(N''验证失败。找不到数据库“CRIOnlineChatRoom”的备份信息。'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\data_backup\CRIOnlineChatRoom_backup_2012_01_30_105001_9541407.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
if @backupSetId is null begin raiserror(N''验证失败。找不到数据库“CRIOnlineChatRoom”的备份信息。'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\data_backup\CRIOnlineChatRoom_backup_2012_01_30_105001_9541407.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
只是判断@backupSetId是否为null
然后做出相应的处理
如果@backupSetId is null
抛出错误后应该直接 加上return退出批