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.