Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The

Design Patterns

As I said at the top of the chapter, recognizing and using design patterns is just as beneficial in Transact-SQL as it is in other languages. Although most published design patterns are geared toward OOP languages, there are many that are equally useful in Transact-SQL. Recognizing OOP design patterns in a non- OOP language such as Transact-SQL requires a keen eye and the ability to think abstractly.

There are a number of parallels between OOP design patterns and the patterns one may find in Transact-SQL. There are also numerous patterns that only apply to set-oriented languages such as Transact-SQL. I'll discuss a few of each in this section, but the list is by no means complete. When you review someone else's Transact-SQL, try ...