Executing Stored procedure in SQL server using BP

[Bhuvnesh_KumarG]

Hi,

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.

------------------------------
Bhuvnesh Kumar Gupta
Sr. Software Engineer
Xavient Information System
Asia/Kolkata
------------------------------

[GopalBhaire]

Try running GetCollection with following SQL Query

EXECUTE SPName @Param1='Param1', @Param2='Param2', @Param3='Param3'

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------