Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Database News

Posted Nov 20, 2006

SQL Hacks: Write queries that won't turn to digital dust

By DatabaseJournal.com Staff

[From O'Reilly]

Sebastopol, CA--Andrew Cumming is a big fan of SQL; he says it's elegant, well designed, and phenomenally useful...but it's not always easy to use: "You can do incredibly powerful queries in just a few lines of code, but then other times you have to tie yourself in knots just to get something trivial done." With coauthor Gordon Russell, Cumming has written SQL Hacks, a collection of 100 tips and tools to help users get more from SQL's power and flexibility, and spend less time tying themselves in knots. "There are a handful of SQL 'cliches' or 'phrases' that I use all the time, but not everyone knows about them," says Cumming. "They save a lot of time and once they get under your skin, you can use them without thinking about them."

The article continues at http://press.oreilly.com/pub/pr/1651



Database News Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM