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

Summary

In this chapter we discussed common design elements—idioms and patterns—in Transact-SQL code. You learned about the importance of taking idiomatic, or natural, approaches to building software. Hopefully, you came to understand that deviating from established conventions and straightforward approaches comes at a cost—increased program complexity—and that you should avoid it when you can. You learned about some of the idioms and design patterns commonly used in Transact-SQL and the differences between idioms and patterns.