Debug stored procedures and oracle debug stored procedures

Debug stored procedures and oracle debug stored procedures
Problem background

N lines of code are written in the stored procedure. As soon as the result is run, an error is reported in the database. So how can we immediately test the village crude process after writing the stored procedure?

Certificate ----------------------------------------------------------------------------------------------------------------------------------------------------------

Difficulties

1, do not write T-SQL to correctly execute the Stored Procedure

Certificate ----------------------------------------------------------------------------------------------------------------------------------------------------------

Proposed Solution

When you want to debug the stored procedure, Microsoft must have already thought of and done it. Microsoft must have developed a "silly" tool for those who do not have good database programming skills. We should look at the stored procedure with two more eyes. We can certainly find them.

Bytes ------------------------------------------------------------------------------------------------------

Practice Process

The following prompt box is displayed:

Then confirm the execution and automatically generate the T-SQL to execute the stored procedure.

The following is a one-step debugging in the T-SQL Statement by F11.

Note that the output window shows the real-time value of each variable.

Certificate ----------------------------------------------------------------------------------------------------------------------------------------------------------

Summary

1. The software designer has come up with and developed it. Such a software development team is more powerful.

2. When you encounter difficulties, you may have to look at the difficulties. The answer may be something you didn't think.

3. This method is suitable for junior developers. A more efficient method is to master T-SQL.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.