TRY
CATCH
需求:Catch exception並insert後繼續跑迴圈,故將TRY、CATCH包在WHILE內
open Database_Cursor
fetch next from Database_Cursor into @DatabaseName
WHILE @@fetch_status = 0
BEGIN
BEGIN TRY
END TRY
--Error handling
BEGIN CATCH
END CATCH
open Database_Cursor
fetch next from Database_Cursor into @DatabaseName
END
-- 釋放資源
close Database_Cursor
deallocate Database_Cursor