DirectedInsight
  Home | Javascript | ASP | Database | Solutions | Misc.
NEWEST
Different ways to show the user they're wrong.
Helpful
Some simple queries that can save you some research time
NEWER
Complete AJAX example.
COOL
Dynamic file upload fields

Database/SQL samples and demos

Procedure expects parameter
The error only shows up when I run it against the new SQL 2000 server, the old SQL 7 box runs it just fine.

Default values and NULL
Specifying a default value for a column in a table or a parameter in a stored procedure has no effect if you pass NULL as the value. The article tells you why and shows a simple work around.

Helper Queries
Some simple queries that can save you some time and research efforts.