sql语句出错后继续执行后面的语句,谢谢啦

2025-03-24 03:44:21
推荐回答(2个)
回答1:

使用BEGIN TRY....END TRY进行分开监控!

BEGIN TRY
ALTER TABLE [ss_flashes] drop [flash_1]
END TRY
BEGIN CATCH
PRINT '语句已出错'
END CATCH
ALTER TABLE [SS_IMAGES] DROP [FLASH_2]

回答2:

对每一个语句进行异常截获;
截获异常后,不进行处理。