Try catch in SQL
BEGIN TRY   BEGIN TRANSACTION INSERT_DATA  EXEC SP_Data_Insert   COMMIT TRANSACTION INSERT_DATA...
Tags: data, sqlserver, development