how to test stored procedure

[vanik]

hello friends, please tell me, how to test and what to test in stored procedure(MSSQL server)


thank you

vani

[slinkanand]

DbUnit works best as a database seeding framework. If you’d like to test a stored proc, then use DbUnit to seed the database with a known set of data, then call the stored proc via your test case and assert that returns the desired result.

[vanik]

Thank you Anank thank you very much