vliet (11/22/2013)

---

One concept not yet mentioned are transactions. When you change anything in a database, always start with a BEGIN TRANSACTION and check the number of rows, or even better, check the results of your UPDATEs, INSERTs and DELETEs in every table affected before you COMMIT. Ever forget to select an essential part of a WHERE clause of an UPDATE statement? ROLLBACK and your out of trouble. But maybe that's just me ...