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 here 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 (see here how to create one) 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