CHAPTER 16

image

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 ...

Get Beginning SQL Server for Developers, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.