Create Unit Tests for SQL Server 2008 Database and all included tables, stored procedures, functions Using Visual Studio 2010 Database Project & Visual Basic. Below is an article that descrips in detail what I need done for my database. Don not bid you do not have direct experience creating unit tests for SQL Server 2008 stored procedures, functions.
Must have great communication skills and excellent understanding of SQL Server, Visual Studio and Visual Basic, Instant messenger is required for clarification and details about the project.
In this article they discuss about unit testing SQL Server 2008 Database project using Visual Studio 2010. As Unit tests test the part of the program integration testing becomes easier, moreover unit tests help enhancing, maintaining or extending a solution provided they are well written. This is first part of this series “How to unit test SQL Server 2008 database using Visual Studio 2010”. The next parts of this series are listed as well.
How to unit test SQL Server 2008 database using Visual Studio 2010 [url removed, login to view]
Attached is the example code from the article listed above.