Control-of-Flow and CASE Expressions


T-SQL has always included additional control-of-flow statements useful for writing procedural code. SQL employs a peculiar three-valued logic that is different from most other programming languages’ Boolean logic. I begin this chapter with a discussion of SQL three-valued logic, then I move on to the IF...ELSE, WHILE, and other T-SQL controlof-flow constructs, and finish up with a discussion of CASE expressions and CASE-derived functions.


Boolean Expression Statement Block Error Handling Service Broker Case Expression 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Michael Coles 2007

Personalised recommendations