Basic Defensive Database Programming Techniques

We can all recognise good-quality database code: It doesn't break with every change in the server's configuration, or on upgrade....