Pete FreitagSeptember 14, 2005
SQL to Select a random row from a database table
There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax.
August 30, 2005
Multiple Dynamic Inserts with SQL
If you have ever had to do lots of SQL INSERT statements you will know that they can get pretty slow. When looking for ways to speed up some inserts, I noticed that you can use a SELECT subquery to provide the values.
May 17, 2005
The persistence of really bad ideas
Seth Godin has a great post called The persistence of really bad ideas, in which he rants about how web developers always seam to use select boxes for picking states and countries:There are fifty states. This is a problem.
