Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours

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