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.

  1. 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.
  2. To move a parameter, click the name of the parameter and drag it where you want to move it.
  3. To delete a parameter, select the parameter that you want to delete and click Delete
  4. 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.
  5. If the function requires values for all of its parameters, select Return null on null input.

Next, select

SQL statements

General