-
Double-click tMSSqlSP to open its
Basic settings view.
-
Fill in the Host, Port, Schema, Database, Username, and Password
fields with your MS SQL Server connection details.
-
In the SP Name field, enter the name of
the stored procedure to be used. In this example, it is QueryPerson.
-
Click the [...] button next to Edit schema to open the schema editor.
Click OK to close the schema editor and
accept the propagation prompted by the pop-up dialog box.
-
In the Parameters area, click the
[+] button to add three rows and select
a schema column and its type for each row. In this example, the id and name
columns are of type IN, and the person column is of type RECORD SET.