THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Alexander Kuznetsov

Database Unit Testing: coverage reports

Apparently test coverage reports are not available for Transact SQL development yet. Because they are very useful in C# development, I submitted a suggestion:

 

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=375333

 

Pls vote.

Published Monday, October 13, 2008 3:37 PM by Alexander Kuznetsov

Comments

 

cr8nk said:

I voted for this one right away.  I have a way of doing this in VSDB that doesn't make me feel that great inside.  I used this guys method of naming unit tests http://www.eggheadcafe.com/articles/visual_studio_2005_unit_test_order_methods.asp

and then inserted the name of every proc, function, trigger and view into a temp table as it is called.  I can then measure against the objects deployed in the database.  I would like built in support.

October 13, 2008 6:47 PM
New Comments to this post are disabled

About Alexander Kuznetsov

Alex Kuznetsov has been working with object oriented languages, mostly C# and C++, as well as with databases for more than a decade. He has worked with Sybase, SQL Server, Oracle and DB2. He regularly blogs on sqlblog.com, mostly about database unit testing, defensive programming, and query optimization. Alex has written a book entitled "Defensive Database Programming with Transact-SQL" and several articles on simple-talk.com and devx.com. Currently he works as an agile developer.

This Blog

Syndication

Privacy Statement