In this chapter, you will learn about:
• SELECT statements
• INSERT, UPDATE, and DELETE statements
• Advanced query techniques
The important thing is not to stop questioning.
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 ...