Understanding T-SQL Programming Logic

  • Kathi Kellenberger


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 write a script that 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 learn in this chapter.


Programming Logic Error Message Select Statement Table Variable Code Section 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Kathi Kellenberger 2009

Authors and Affiliations

  • Kathi Kellenberger

There are no affiliations available

Personalised recommendations