![]() |
![]() |
We are currently migrating this forum over to our HelpSystems domain. Please post all new threads in our new HelpSystems Community Portal. |
![]() |
|
![]() |
AutoMate Discussion | ![]() |
help :
faq :
home
|
||
Latest News:
|
latest topics : statistics |
Topic Title: Passing Named Parameters to SQL Server Stored Procedures. Topic Summary: Created On: 11/25/2014 07:19 PM Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() Answer: Phillip, Have you attempted to use your string in the SQL Query action? It would be the same way you would write it in SQL management Studio or how you have referenced it in your original post. | ||||||||||
![]() |
||||||||||
How can I pass named parameters to a SQL Server Stored Procedure. eg if I have a stpred proc that has optional paramaters I need to pass the name otherwise it gets confused. This Proc may have input Parameters Declare @P1 varchar(10) = '', @P2 varchar(10)= '', @P3 varchar(10)= '' in SQL I would write
Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder) |
||||||||||
|
||||||||||
![]() |
||||||||||
Phillip,
There is a parameters section in the Stored Procedure action that allows you to pass the parameters as you describe.
------------------------- ![]() Leonard Amabile | Director, Cross Platform Support AutoMate | InterMapper | Skybot | Divisions of HelpSystems T: +1.213.738.1700 | F: +1.213.738.7665 |
||||||||||
|
||||||||||
![]() |
||||||||||
That's kinda vague. Anymore detail? I have checked all of th tabs in the stored proc window and nothing jumps out.
|
||||||||||
|
||||||||||
![]() |
||||||||||
Phillip,
Please see the attached screenshots. The Parameters section is in the bottom left. You will need to click on the add button to add each parameter. I have also attached sample code showing a stored procedure with parameters.
Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder) ------------------------- ![]() Leonard Amabile | Director, Cross Platform Support AutoMate | InterMapper | Skybot | Divisions of HelpSystems T: +1.213.738.1700 | F: +1.213.738.7665 |
||||||||||
|
||||||||||
![]() |
||||||||||
The parameters section allows you to add parameters but does not use there names. The output from the example provided would be Declare @P1 int output exec myProc 'boo', @P1 output The names pprovided are ignored. I have to provide the required parameters in the correct order becuase of this.
|
||||||||||
|
||||||||||
![]() |
||||||||||
Phillip,
Have you attempted to use your string in the SQL Query action? It would be the same way you would write it in SQL management Studio or how you have referenced it in your original post.
------------------------- ![]() Leonard Amabile | Director, Cross Platform Support AutoMate | InterMapper | Skybot | Divisions of HelpSystems T: +1.213.738.1700 | F: +1.213.738.7665 |
||||||||||
|
FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.