cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Run Stored Procedure

Jump to solution

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?

Reply
4 Replies
Workflow Hero

Re: Run Stored Procedure

Jump to solution

Hi,

Do u mean u tried it but no success?

0 Kudos
Reply
Workflow Hero

Re: Run Stored Procedure

Jump to solution

Thanks for the quick response ‌. I am having problems with my connection test, getting a login failed. I also an unsure where to reference the stored procedure.

0 Kudos
Reply
Workflow Hero

Re: Run Stored Procedure

Jump to solution

Should be possible. 

Running an SQL procedure (via the "Execute SQL" action) can look like this:

Connection:

Data Source=(whateveritis);Initial Catalog=(catalog);User ID=un;Password=pw;


Procedure:

exec ProcedureNameHere 
@Item1={WorkflowVariable:textHazardID},
@Item2 ={WorkflowVariable:whatever},
@Item3= {ItemProperty:whatever},

You can then store the output (if any) in a collection or single item, depending on what its returning.

Reply
Workflow Hero

Re: Run Stored Procedure

Jump to solution

Excellent, this is exactly what I needed to get this working. THANK YOU!

Reply