How to check for correct stored procedures and how to check if the triggers are fired or not in Db testing?

LoniT
Profile Answers by LoniT Questions by LoniT
Jul 26th, 2006
3
2794

Showing Answers 1 - 3 of 3 Answers

Amit Bansal

May 9th, 2007

To check the correctness of SP you should have a good knowledge to understand SP(Stored Procedure). You have to understand what are the steps and what about the expected result to execute the SP. Like there is an SP, which helps to insert a row which has two columns in a table then you will execute that SP only and you know the expected result just write one query and check those expected values into the database.
Same procedure you will apply to triggers too. You know at what condition the trigger is fired.

Or if you are using SQL Server database then its very easy to do. Using SQL PROFILER you can check the correctness of SP and trigger too.