Execute command

query vs commands there's a basic difference between them commands modify the data, and queries retrieve the data use this action to execute a sql command in microsoft sql first of all, you'll have to enter credentials for the execute command action you can find out how to do that https //docs procesio com/sql credential how to configure the execute command action? go to the process designers section and open a new or an existing process actions configuration can be performed once they are dragged and dropped on canvas step 1 drag the execute command action from toolbar and drop it on canvas; click on the action to open the properties panel step 2 you can edit the action name step 3 select a credential for the database server https //docs procesio com/sql credential step 4 click on execute command (not configured) card to go to the configurations steps step 5 type your sql query in the editor note you can always add process variables to your query press insert/ctrl+i (windows) or cmd+i (mac) step 6 add the output variable note it has to be defined as a single value object/integer in the output variable, you will see the number of rows affected by the executed command add the output variable step 7 save , validate and run the process step 8 click check instance to view the results based on our command, 2 rows were affected