June 2006
Beginner
456 pages
10h 3m
English
SELECT StatementKnowledge 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:
• How to Build a SELECT Statement
• How to Work with a WHERE Clause
• How to Work with the DISTINCT Clause
• How to Output Your Data as XML
• How to Create Top Values Queries
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 ...
Read now
Unlock full access