Essentials for Effective Coding
Now that you know how to build and work with SQL Server objects, and how to insert, update, and delete data as well as retrieve it, you can move on to more of the T-SQL essentials required to complete your programming knowledge.
The most important area covered by this chapter is probably error handling. After all, no matter how good your code is, if it cannot cope when an error occurs then it will be hard to keep the code stable and reliable. There will always be times that the unexpected happens, from strange input data to something going wrong on the server. However, error handling is not the only ...