HOUR 6. Getting to Know the SELECT Statement

Knowledge of the T-SQL language is vital to your success as a SQL Express administrator or developer. You use the T-SQL language to manipulate the data in your database. Using T-SQL, you can select, insert, update, and delete data. In this hour you’ll learn:

What T-SQL Is

How to Build a SELECT Statement

How to Work with a WHERE Clause

How to Order Your Output

How to Work with the DISTINCT Clause

How to Output Your Data as XML

How to Create Top Values Queries

Introducing T-SQL

T-SQL, or Transact-SQL, is the dialect of the Structured Query Language (SQL) incorporated in SQL Server. To work effectively as a SQL Server developer, you must have a strong grasp of T-SQL. Fortunately, T-SQL ...

Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with O’Reilly online learning.

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