Store procedure testing using DBPro

Question

Hi,

I'm new to Store procedure unit testing. I'm using DBPro. Could any body help me with following query.

Qeury 1 : what is the best way to validate ( use of test condition ) a store procedure under test which does not return any value.

For example only one insert statement is written in store procedure and out put parameter is @result which is set to 1 if store procedure executed successfully.

I'm using data driven approach following Jamie Laflen's article  http://msdn.microsoft.com/en-us/magazine/cc164243.aspx?pr=blog .

Query 2 : What is the best way to validate a store procedure under test which returns a result set.I can't use checksum condition as there are datetime field in database.

For example store procedure returning a list of employee.

Thanks

Sandipan 

Answer 1

Check this article: http://msdn.microsoft.com/en-us/library/dd193286.aspx