How to perform unit testin on Stored Procedure ?

Posted by Mahendrabasutkar under QA (Testing) on 3/14/2012 | Points: 10 | Views : 2200 | Status : [Member] | Replies : 4
How to perform unit testin on Stored Procedure ?
I'm using Sql server 2005.
Is there any Tool, script or any approach to test Stored Procedure.




Regards,
Mahendra




Responses

Posted by: CGN007 on: 3/14/2012 [Member] Silver | Points: 25

Up
0
Down
Please refer the MSDN http://msdn.microsoft.com/en-us/library/aa833169.aspx

Also this http://msdn.microsoft.com/en-us/magazine/cc164243.aspx

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Hmanjarawala on: 3/14/2012 [Member] Bronze | Points: 25

Up
0
Down
Hi mahendra,
follow this

http://www.sqlmag.com/article/tsql3/unit-test-your-stored-procedures
http://msdn.microsoft.com/en-us/library/aa833169.aspx
http://msdn.microsoft.com/en-us/magazine/cc163925.aspx



Mark this as answer, if it helps you.............

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere
http://fieredotnet.wordpress.com/

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 3/14/2012 [Member] Silver | Points: 25

Up
0
Down

Posted by: CGN007 on: 6/29/2012 [Member] Silver | Points: 25

Up
0
Down
Mark as Answer if it helpful to you,that motivates...

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response