[SQL] [架構] Error Handling in WHILE loop

  • 102
  • 0
  • 2016-08-30

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