Practical SQL Queries for Microsoft SQL Server 2008 R2

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

400+ ready-to-use, powerful SQL queries

• Enter, maintain, and retrieve database data
• Search records using the Where clause
• Sort SQL query results with the Order By clause
• Create tables and perform joins on tables
• Perform set operations using Union, Intersect, and Except
• Group data and produce totals with the Group By clause
• Manipulate and transform data using built-in functions
• Create reusable views and user-defined functions
• Use stored procedures to change SQL dynamically based on conditional factors
• Create, maintain, and secure database objects with DDL and DCL
• Deliver SQL query results to end users