Ebook: SQL Hacks

Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. SQL Hacks offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems.;SQL Hacks; Contributors; Acknowledgments; Preface; How to Use This Book; How This Book Is Organized; Conventions; Using Code Examples; How to Contact Us; Got a Hack?; Safari Enabled; 1. SQL Fundamentals; Switches; Microsoft SQL Server; Oracle; List your tables in Oracle; Import a file of SQL into Oracle; MySQL; List your tables in MySQL; Import a file of SQL into MySQL; Access; Import a file of SQL commands; PostgreSQL; List your tables in Postgres; Import a file into PostgreSQL; DB2; Connect to SQL from a Program; Other C♯ considerations; Java; Perl; PHP; Ruby; Perform Conditional INSERTs.