Beginning SQL Server 2008 Express for Developers: From Novice to Professional

Chapter 12. T-SQL Essentials

Now that you know how to build and work with SSE objects and insert, update, and delete data as well as retrieve it, we can move on to more of the T-SQL essentials required to complete your programming knowledge.

Potentially the most important area covered by this chapter is error handling. After all, no matter how good your code is, if it cannot cope when an error occurs, it will be hard to keep the code stable and reliable. There will always be times that the unexpected happens, either from strange input data or from something happening in the server. However, this is not the only area of interest. You will be looking at joining tables, performing aggregations of data, and grouping data. Finally, sometimes you'll ...