SQL Server 2008 Transact-SQL Recipes

Cover -- Contents -- About the Author -- About the Technical Reviewer -- Acknowledgments -- Introduction -- CHAPTER 1 SELECT -- The Basic SELECT Statement -- Selecting Specific Columns from a Table -- Selecting Every Column for Every Row -- Selective Querying Using a Basic WHERE Clause -- Using the WHERE Clause to Specify Rows Returned in the Result Set -- Combining Search Conditions -- Negating a Search Condition -- Keeping Your WHERE Clause Unambiguous -- Using Operators and Expressions -- Using BETWEEN for Date Range Searches -- Using Comparisons -- Checking for NULL Values -- Returning Rows Based on a List of Values -- Using Wildcards with LIKE -- Declaring and Assigning Values to Variables -- Grouping Data -- Using the GROUP BY Clause -- Using GROUP BY ALL -- Selectively Querying Grouped Data Using HAVING -- Ordering Results -- Using the ORDER BY Clause -- Using the TOP Keyword with Ordered Results -- SELECT Clause Techniques -- Using DISTINCT to Remove Duplicate Values -- Using DISTINCT in Aggregate Functions -- Using Column Aliases -- Using SELECT to Create a Script -- Performing String Concatenation -- Creating a Comma-Delimited List Using SELECT -- Using the INTO Clause -- Subqueries -- Using Subqueries to Check for Matches -- Querying from More Than One Data Source -- Using INNER Joins -- Using OUTER Joins -- Using CROSS Joins -- Referencing a Single Table Multiple Times in the Same Query -- Using Derived Tables -- Combining Result Sets with UNION -- Using APPLY to Invoke a Table-Valued Function for Each Row -- Using CROSS APPLY -- Using OUTER APPLY -- Advanced Techniques for Data Sources -- Using the TABLESAMPLE to Return Random Rows -- Using PIVOT to Convert Single Column Values into Multiple Columns and Aggregate Data -- Normalizing Data with UNPIVOT -- Returning Distinct or Matching Rows Using EXCEPT and INTERSECT -- Summarizing Data -- Summarizing Data Using CUBE -- Summarizing Data Using ROLLUP -- Creating Custom Summaries Using Grouping Sets -- Revealing Rows Generated by GROUPING -- Advanced Group-Level Identification with GROUPING_ID -- Common Table Expressions -- Using a Non-Recursive Common Table Expression -- Using a Recursive Common Table Expression -- CHAPTER 2 Perform, Capture, and Track Data Modifications -- INSERT -- Inserting a Row into a Table -- Inserting a Row Using Default Values -- Explicitly Inserting a Value into an IDENTITY Column -- Inserting a Row into a Table with a uniqueidentifier Column -- Inserting Rows Using an INSERT ... SELECT Statement -- Inserting Data from a Stored Procedure Call -- Inserting Multiple Rows with VALUES -- Using VALUES As a Table Source -- UPDATE -- Updating a Single Row -- Updating Rows Based on a FROM and WHERE Clause -- Updating Large Value Data Type Columns -- Inserting or Updating an Image File Using OPENROWSET and BULK -- Storing Unstructured Data on the File System While Maintaining SQL Server Transactional Control -- Assigning and Modifying Database Values "in Place " -- DELETE -- Deleting Rows -- Truncating a Table -- Advanced Data Modification Techniques -- Chunking Data Modifications with TOP -- Executing INSERTs, UPDATEs, and DELETEs in a Single Statement -- Capturing and Tracking Data Modification Changes -- Returning Rows Affected by a.