6. Transact-SQL Programming

Certification Objectives

6.01 Retrieve Data to Support Ad Hoc and Recurring Queries 6.02 Manipulate Relational Data 6.03 Manage Databases by Using Transact-SQL ✓ Two-Minute Drill Q&A Self Test

The focus of this chapter is on understanding the SQL and how it applies to the management, control, and access to data stored in SQL Server databases. I will not worry about the debate of the pronunciation of SQL or whether Transact-SQL can really be considered standards-based SQL. When you are finished reading this chapter, I want you to be comfortable writing queries to assist your users. In order to do this, the chapter will take you on a journey through the following topics: