Manage transactions when changing tables

Software ResiliencyCode Reliability

Why you should care

Transactions are vital in SQL as one of them is the representation of one or more changes to the database. For instance, anytime a record is created, updated or deleted in the database, a transaction is performed in that database.

Therefore, it is recommended to manage transactions as they ensure data integrity and handle database errors as well.

Business Impacts

When involving transactions, it is important to note that the risks involved can hamper productivity since losing transactions is equivalent to losing records requiring the code to be rewritten. Loss of Productivity results in loss of time causing unsatisfactory work.

Production Risk
5362

CAST Recommendations

References

https://www.tutorialspoint.com/sql/sql-transactions.htm

Style Guide

How we detect

This code insight manages transactions with Functions and Procedures when a table is inserted, updated or deleted.

5362

About CAST and Highlight’s Code Insights

Over the last 25 years, CAST has leveraged unique knowledge on software quality measurement by analyzing thousands of applications and billions of lines of code. Based on this experience and community standards on programming best practices, Highlight implements hundreds of code insights across 15+ technologies to calculate health factors of a software.

See featuresHow it works