BEGIN TRY
BEGIN TRANSACTION INSERT_DATA
EXEC SP_Data_Insert
COMMIT TRANSACTION INSERT_DATA
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION INSERT_DATA
SELECT ERROR_NUMBER() AS EcrorNumber,
ERROR SEVERITY() AS ErrorSeverity,
ERROR_STATE() AS Errorstate,
ERROR PROCEDURE() AS ErrorProcedure,
ERROR LINE() AS Errorline,
ERROR NESSAGE() AS ErrorMessage
END CATCH
Clever Cottonmouth
Posted on
Try catch in SQL
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)