I have an Azure SQL database and an on-premise nintex workflow environment. I would like to use an Execute SQL action to run a stored procedure (this stored procedure updates the SQL database with parameters from the list item).
Is this possible?
Solved! Go to Solution.
Should be possible.
Running an SQL procedure (via the "Execute SQL" action) can look like this:
Data Source=(whateveritis);Initial Catalog=(catalog);User ID=un;Password=pw;
You can then store the output (if any) in a collection or single item, depending on what its returning.