How to debug a stored procedure in your Sql Server 2005
Posted by: Wortzels blog,
on 30 Sep 2007 |
View original | Bookmarked: 0 time(s)
In my company there is a sophisticate logic layer in Sql Server DB. In order to write tests that will check this code we need to write some T-SQL code. The test methods including a serious of initialization script before and after each one of them. Im going to share you with a very helpful way to debuging this important code by using SQLCLR abilities.The first thing we should do is to open a new Sql Database Project.
Create a new SQL Server Project, by adding a new project and selecting SQL Server...