Searching for "stored procedure in slq server"

Searching for "stored procedure in slq server"

  
I'd like to know if is possible import a stored procedure from a sql server application, or if
outsystem allow us to create a store procedure.

thanks for all the attention,


Luis Pereira

Hi Luis,

Yes, you can call a stored procedure using an advanced query with EXEC yourprocedurename provided that the OutSystems runtime user has permissions for it. Remember that you'll always need to define an output structure, even if the stored procedure does not return anything.

If you are doing new business logic (instead of reusing an existing sp) I would recommend you to do it in Service Studio, as stored procedures are usually a lot harder to maintain.

Cheers,
Tiago Simões
Hi Tiago, do you know if it is possible to retrieve the output of a stored procedure with an advanced sql query? Input i believe, but output i'm quite ceptic...

Best Regards,

Diogo C S Cordeiro
Hi Diogo,

Yes it is, you just need to define an output structure with the same attributes as the stored procedure return.

Cheers,
Tiago Simões