Chapter 7 Quick Reference

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.