May 31 2022 06:52 AM - edited May 31 2022 07:03 AM
Hi,
I currently have a Stored Procedure that does not have any Input Parameters, it basically updates a Calendar Table, setting columns like CurrentDay, PreviousDay, CurrentMonth etc... to 1 or 0 if the conditions matches.
I wanted to use Power Automate to run this stored procedure at 12:00 everyday but it failed because Power Automate only executes Stored Procedures with an Input Parameter
https://docs.microsoft.com/en-us/connectors/sql/#execute-stored-procedure-(v2)
What is the most efficient way to add an Input Parameter to my current stored procedure but basically does nothing but still does the update is meant to do.
Thanks
Jun 06 2022 05:35 AM
Hi @SqlAvfc -- You could add a parameter similar to that shown below. The parameter does nothing at all but satisfies the Power Automate stored procedure requirement. Take care.
create stored procedure ThisIsAstoredProcedure
@RequiredParam BIT
AS
'Logic Here'
To execute the stored procedure:
EXEC ThisIsAstoredProcedure @RequiredParam=1
Jan 18 2024 03:11 PM