Rob Caron

Developer-related topics and other stuff.

Sachin Rekhi on Database Unit Testing

Sachin Rekhi on Database Unit Testing

  • Comments 3

I don't know how popular the blogs from the Team Edition for Database Pros team have grown, so I wanted to draw some attention to Sachin Rekhi's recent posts on database unit testing.   

From: Sachin Rekhi's Ramblings

Sachin Rekhi is a Program Manager on Team Edition for Database Professionals and has one of the most information-rich blogs for it. If you have any interest in database development and you haven't added this blog to your reading list, you're really missing out.

981

Tags:  |

  • Great~~~thanks
  • IMO, the DB Unit Tests don't seem so valuable to me yet.  I would love to be able to write tests against my stored procedures at the SQL level.  But the things I want to test are that my GetTop10Products stored procedure actually returns the top 10 products based on the sample data I setup.  I don't want to test that it returns a non-empty recordset, or that it returns a recordset with a rowcount of 10.  I need to know if the actual data returned is correct (eg. that it returns products 13, 81, 91, 43...29, etc)

    Until we get to the point where tests such as that are easy, I don't think we will be realizing the true value of database unit tests.
  • Despre database unit testing, aiciIn general despre Team SystemTeam System Dev Center, hostat tot pe...
Page 1 of 1 (3 items)
Leave a Comment
  • Please add 6 and 8 and type the answer here:
  • Post