© Elizabeth Noble 2020
Elizabeth NoblePro T-SQL 2019https://doi.org/10.1007/978-1-4842-5590-2_4

4. Designing T-SQL

Elizabeth Noble
Roswell, GA, USA
In the earlier chapters in the section on “Building Understandable T-SQL,” I have covered the various data types available and how to select the correct data type. I have also discussed several database objects available when you write your T-SQL and the pros and cons of using each database object. In the previous chapter, I explained the importance of making your code readable for yourself and others. I will finish up this section by going over the various options when designing your T-SQL code.
When writing T-SQL for your applications, I am a huge fan of using stored procedures. There are many advantages ...

Get Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.