Stored Procedures - Githubissues

bestlong / node-red-contrib-mssql-plus

A Node-RED node to read and write to Microsoft MS SQL Databases

MIT License

31 stars 18 forks source link

Closed Humphaz closed 4 years ago

Humphaz commented 4 years ago

Hi,

Is there any way of supporting the execution of stored procedures.

I notice in the Node.JS MSSQL that stored procedures are called in a different way, is there support for it node-red-contrib-mssql-plus.

Best Regards,

Glyn

pedrossag commented 4 years ago

Hi, a temporary workaround could be the exec node that calls a batch script. The batch runs SQLCMD that executes the SP.

Regards, Hannes

Steve-Mcl commented 4 years ago

No need for work around - stored procedures work already...