Up:: T-SQL

SQL Data entry template

BEGIN TRY
    BEGIN TRANSACTION TRN_Datachange
 
        INSERT INTO TableName (Col1, Col2)
        VALUES
            ('123', '567'),
            ('654', '287')
 
        UPDATE TableName
        SET Col1 = '7654'
        WHERE ID = 1
 
    COMMIT TRANSACTION TRN_Datachange
END TRY
BEGIN CATCH
    ROLLBACK TRANSACTION TRN_Datachange
 
    DECLARE @ErrorNumber INT = ERROR_NUMBER();
    DECLARE @ErrorLine INT = ERROR_LINE();
 
    PRINT 'Actual error number: ' + CAST(@ErrorNumber AS VARCHAR(10));
    PRINT 'Actual line number: ' + CAST(@ErrorLine AS VARCHAR(10));
 
    THROW;
END CATCH

---

📇 Additional Metadata

• 🗂 Type:: note
• 🏷️ Tags:: Programming
• 📡 Status:: #status/🌲