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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

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

Leave a Comment

(required) 
(required) 
Submit

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 at DRW Trading Group in Chicago, where he leads a team of developers, practicing agile development, defensive programming, TDD, and database unit testing.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement