SQL to Select a random row from a database table

databases 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.

This entry was:

Multiple Dynamic Inserts with SQL

databases 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.

This entry was:

The persistence of really bad ideas

web 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.

This entry was:


did you hack my cf?