© Elizabeth Noble 2020Elizabeth NoblePro T-SQL 2019https://doi.org/10.1007/978-1-4842-5590-2_4
4. Designing T-SQL
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 ...