Code
SQL Hacks
2008-11-25 14:05:18
Here is a slide show presentation for a talk I'm giving at Ductape this evening. It contains some useful SQL Tricks for getting the most out of your data and also some nifty stuff you can get SQL to produce.
Overview
* Retrieving Structural Information
* Retrieving SQL-Generated Data
* Paging Output
* Calculating distance from GPS co-ordinates
* Generate All Possible Permutations
* Generate a Random Permutations
* Creating ASCII Graphs with pure SQL
* Creating a Calendar with pure SQL
* Google-Like Search Results
Files
SQL Hacks Power Point Presentation
