Abstract
Even though the primary purpose of T-SQL is to retrieve and manipulate data, like other programming languages, it also contains logic elements. Most of the time you will write T-SQL statements that retrieve or update data, but you can also set up loops and write code with conditional flow. Often database administrators write scripts in T-SQL to perform maintenance tasks that require more than just retrieving or updating data. For example, you might need to write a script that checks the last backup date of all databases on the server or checks the free space of all the databases. Although most administrative tasks are beyond the scope of this book, you may find many uses in your environment for the techniques you will learn in this chapter.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Kathi Kellenberger
About this chapter
Cite this chapter
Kellenberger, K., Shaw, S. (2014). Understanding T-SQL Programming Logic. In: Beginning T-SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0046-9_12
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0046-9_12
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0047-6
Online ISBN: 978-1-4842-0046-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books