1.

How To Test Database Procedures And Triggers?

Answer»

To test database procedures and triggers, input and output parameters must be known. EXEC statement can be USED to run the PROCEDURE and examine the behaviour of the tables.

  • Open the database project in solution explorer
  • Now in View menu, click the database schema
  • Open the project folder from schema View menu
  • Right click on the object that has to be tested, and then click on the dialog box that says CREATE Unit Tests
  • After that create a new language test project
  • Select either a) Insert the unit test or b) Create a new test and then click OK
  • Project that has to be configured will be done by CLICKING on the Project CONFIGURATION dialog box.
  • Once it configured click on OK

To test database procedures and triggers, input and output parameters must be known. EXEC statement can be used to run the procedure and examine the behaviour of the tables.


Discussion

No Comment Found

Related InterviewSolutions