Skip to Main Content
Beginning T-SQL
book

Beginning T-SQL

by Kathi Kellenberger, Scott Shaw
August 2014
Beginner content levelBeginner
496 pages
12h 26m
English
Apress
Content preview from Beginning T-SQL

CHAPTER 12

image

Understanding T-SQL Programming Logic

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

T-SQL Fundamentals, 4th Edition

T-SQL Fundamentals, 4th Edition

Itzik Ben-Gan
Learning SQL

Learning SQL

Ben Forta

Publisher Resources

ISBN: 9781484200469Purchase book