SQL Server Developer Center: Test Run: Automate Testing of Your Stored Procs

SQL Server Developer Center: Test Run: Automate Testing of Your Stored Procs: "
Automate Testing of Your Stored Procs



James McCaffrey


Download the code for this article: TestRun0409.exe (124KB)


Many Windows�-based applications have a SQL Server� back-end component that contains stored procedures. Although techniques to automatically test functions in the front-end code are well known, the techniques to write test automation for stored procedures are not. SQL Server 2005 will provide greatly enhanced integration with the Microsoft� .NET Framework including the ability to write stored procedures in C# and other .NET-targeted languages. This will certainly increase the use of stored procedures and the importance of testing them thoroughly.
In this column I'll walk you through the creation of a simple but representative SQL stored procedure and will then show you how to quickly write powerful test automation that verifies its functionality so that you'll be ready when you start using SQL Server 2005. I will also explain some key principles of writing test automation for SQL stored procedures."