User Defined Functions (UDFs) may be added, dropped, or altered with the Data Builder.
Right click on the Functions folder and select CREATE FUNCTION to view the create function dialog. This dialog allows you to edit a function in the GUI rather than write the SQL code to create the function by hand.
|
UDFs may return any data type supported by VistaDB or a TABLE. Stored Procedures may only return an integer type. Other returns must be passed through an OUT referenced parameter.