SQL function -- 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.
- 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.
- 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 Insert and enter the appropriate column information. Clicking on
the type will cause a drop-down list to appear that you can select a new type from.
- If the function requires values for all of its parameters, select Return null on null input.
Next, select
SQL statements
General