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

4. Designing T-SQL

Elizabeth Noble
(1)
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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.