Actions - SQL Update
Overview
Overview
The SQL Update Action item is used to execute a query which will update data. Ideally a Stored Procedure will be created which is then executed from the Action using a small SQL statement.
Steps
Steps
Add an Item to the Action
In the Type column, select SQL Update
Add a Description for reference purposes
Right-click and select Edit SQL
Click the Template button to generate the basic SQL required for this Action item.
Note
Note
The Input Parameters that can be used in the SQL differ according to the module that the Action is linked to. The Parameter list can be found in the left panel of the SQL Editor.
SQL Template
SQL Template
execute procedure [PROCEDURE_NAME](:PARAM1, :PARAM2)