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.
KeywordsBoolean Expression Statement Block Error Handling Service Broker Case Expression
Unable to display preview. Download preview PDF.