O'Reilly logo

All-In-One MCITP SQL Server 2005 Database Developer by Darril Gibson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required