Use a sp for a few sps in a sturried process

In this tutorial, we want to write a process sponder that will do all the extra work, edit, and delete, and shorten and manage the security sps.

This is the first time I’ve been working on a site that I am indebted to. Hope you find it useful and useful.

To do this, we first create a table

Next, we introduce a series of basic information

The result of the code snippet is high

Well, come to the exciting part of Marmon, that is to say write the main part of the proceedingsFirst, by pressing F5, we execute the above code

In explaining this code, I have to say that we will place an additional field in our preferred procedure, which is the value of the three insert or update or deletestatements that are checked with if if any of the above expressions are in the last field. It runs for example

Firstinsert the insert

Let’s take a look at our decision

The result is the opening of the window of the stevedore  and the values ​​we enter into

If you click the ok button, we will add a row

Also, if you use the update and delete statements in the statement type field, performs the related operations