Stored Procedure

[gua_gunners]

Hi,

Has anyone know how to return a result from SQL Stored Procedure ?

I need to analyse the table from the strored proc results

Thank You !

[AlexanderFillbrunn]

Hi,
what DB are you using? Generally I think you can use the DB Query Reader node. In MySQL, for example, you would use CALL MyStoredProcedure(); as query.
Kind regards
Alexander

[gua_gunners]

Hi @AlexanderFillbrunn,

Currently Im using SQL Server as my DB. Would it be the same if query I use CALL MyStoredProcedure(); in theDB Query Node ? Or there is other query to execute
my stored proc using SQL Server as DB ?

Thanks !

[AlexanderFillbrunn]

Hi,
On SQL Server you use EXEC MyStoredProcedure @MyParam=5. You can find more info here.
Kind regards
Alexander

[gua_gunners]

Alright thank you @AlexanderFillbrunn, instead of using EXEC MyStoredProcedure @MyParam=5 Im writing MyStoredProcedure only in the DB Query Reader and it worked.
Again thank you for the reply, Cheers !