Unit Testing Database Code
Summary:
The problem is this: You have an SQL database, some stored procedures, and a layer of code sitting between your application and the database. How can you put tests in place to make sure your code really is reading and writing the right data from the database?