Owning this reference, which covers everything from the components of a table to performing batch updates, is a must! Beginning with tips for the person who is programming with SQL for the first time, SQL Tips and Techniques grows with your skills. You can start with Tip 1, "Understanding the Definition of a Database," and by the last Tip, "Using ADO to Perform Transaction-Based Processing", you will have covered all aspects of SQL. Or, you can simply keep this book as a comprehensive reference for answering specific SQL questions quickly. However you read it, this invaluable reference will be the only SQL book you need on your shelf!
Covers all aspects of SQL!

• Speeding Up Table to Table Data Transfers
• Preventing Null Values in a Column
• Removing Duplicate Data
• Using Wildcard Characters
• Using a Trigger to Send an Email Message
• Combining the Results of Two Queries
• Understanding Nested Subqueries
• Using Keywords to Introduce a Subquery
• Creating MS-SQL Server Temporary Tables
• Building Dynamic Web Pages
• Removing a Default from a Database
• Using Nested Queries to Work with Multiple Tables
• Changing Primary and Foreign Keys
• Creating a MS-SQL Server Backup Device
• Adding Data to Specific Columns in a Row
• Changing Values in Multiple Rows at Once
• Executing Dynamic SQL Statements
• Working with Multiple Recordsets