In this chapter we discussed common design elementsidioms and patternsin 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 costincreased program complexityand 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.