Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

CHAPTER 13 ESSENTIALS FOR EFFECTIVE CODING (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) Msg 51200, Level 16, State 1, Line 5 Inner level throw Error handling and having the ability to control errors will lead to code that is more robust, and when an error occurs it can be tracked in a more constructive fashion as well as handled in a controlled manner. Remembering to use a semicolon in the statement prior to a THROW may seem odd; however, this is Microsoft trying to take you down the route of statement termination via a delimiter. Summary The text for this chapter is not the most fluid, but the information will be very useful as you start using SQL Server. Each section you have read contains a great deal of useful and pertinent information, and rereading the chapter and maybe even trying out different ideas based on the basics demonstrated will give you a stronger understanding of what is happening. The main areas of focus were error handling and joining tables to return results. Also looking at some of the system predefined functions and how useful they can be is important, as you will use some of these functions a great number of times when coding. Take time to fully understand what is happening and how you can use these two features.