Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step
| | ||
| | ||
| | ||
| To | Do This |
|---|---|
| Query databases | Use the SELECT, CASE, JOIN, AND, and OR operators. |
| Select data from multiple tables | Use INNER JOIN, LEFT JOIN, RIGHT JOIN, or FULL JOIN. |
| Obtain summarized values | Use aggregate functions: COUNT , SUM , AVG , and MIN . |
| Perform complex operations Set information about the system or security | Use system-supplied scalar functions: configuration, cursor, date time, mathematical, security, and other functions. |
| Define your own functions | Use UDFs to accept and return values in new functions. |
| Store, retrieve, or manipulate XML documents | Use the new xml datatype in SQL Server 2005. |
| | ||
| | ||
| | ||