SQL procedure -- Parameters
On the Parameters tab, you can specify the parameters that the program requires. You can use the defaults or specify your
own values for the columns for each parameter.
- Click the Parameters tab.
- To add a new parameter, select the parameter after which you want to add the new parameter and click
Insert. The new parameter
appears after the one that is currently selected, or at the top if there are no parameters.
- Clicking the type will cause a drop-down list to appear that you can select a new type from.
- To move a parameter, click the name of the parameter and drag it where you want to move it.
- To delete a parameter, select the parameter that you want to delete and click Delete.
- If you want to define a parameter, click the space under the column headings and enter the appropriate column information.
Next, select: