O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required