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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.