https://community.blueprism.com/t5/Product-Forum/Executing-Stored-procedure-in-SQL-server-using-BP/m-p/68166#M20771 <P>Try running GetCollection with following SQL Query</P> <PRE class="language-markup">EXECUTE SPName @Param1='Param1', @Param2='Param2', @Param3='Param3'</PRE> <P></P><BR /><BR />------------------------------<BR />Gopal Bhaire<BR />Analyst<BR />Accenture<BR />------------------------------<BR /> Fri, 26 Jul 2019 05:38:00 GMT GopalBhaire 2019-07-26T05:38:00Z https://community.blueprism.com/t5/Product-Forum/Executing-Stored-procedure-in-SQL-server-using-BP/m-p/68165#M20770 Hi,<BR /><BR />We have a requirement to execute a stored procedure in SQL server using BP. We are able to configure and set connection with the SQL server. But we are not sure how to execute a stored procedure in SQL: server DB using BP. Our stored procedure accepts three inputs.<BR /><BR />------------------------------<BR />Bhuvnesh Kumar Gupta<BR />Sr. Software Engineer<BR />Xavient Information System<BR />Asia/Kolkata<BR />------------------------------<BR /> Thu, 25 Jul 2019 14:44:00 GMT https://community.blueprism.com/t5/Product-Forum/Executing-Stored-procedure-in-SQL-server-using-BP/m-p/68165#M20770 Bhuvnesh_KumarG 2019-07-25T14:44:00Z https://community.blueprism.com/t5/Product-Forum/Executing-Stored-procedure-in-SQL-server-using-BP/m-p/68166#M20771 <P>Try running GetCollection with following SQL Query</P> <PRE class="language-markup">EXECUTE SPName @Param1='Param1', @Param2='Param2', @Param3='Param3'</PRE> <P></P><BR /><BR />------------------------------<BR />Gopal Bhaire<BR />Analyst<BR />Accenture<BR />------------------------------<BR /> Fri, 26 Jul 2019 05:38:00 GMT https://community.blueprism.com/t5/Product-Forum/Executing-Stored-procedure-in-SQL-server-using-BP/m-p/68166#M20771 GopalBhaire 2019-07-26T05:38:00Z