CHAPTER 4Transact-SQL

In this chapter, you will learn about:

• Transact-SQL

• SELECT statements

• INSERT, UPDATE, and DELETE statements

• Advanced query techniques

The important thing is not to stop questioning.

—Albert Einstein

The database has the answers. All you have to do is ask. Of course, you need to know how to ask, and the method of asking in SQL Server 2005 is Transact-SQL. For those of you preparing to take the 70-431 or 70-442 tests, you'll need to know T-SQL's SELECT statement inside and out. When the DML statements are tested, they are tested rather deeply. T-SQL is not tested on the 70-441 test.

In this chapter, we'll start with the basics on the SELECT statement, expand to all the Data Manipulation Language (DML) statements ...

Get MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.