O'Reilly logo

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

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

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

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