topic Re: Custom Extensions Creator - use Stored procedures in Extensions

Custom Extensions Creator - use Stored procedures

holst — Fri, 04 Oct 2024 08:27:06 GMT

Hi,

I like the new Custom Extensions Creator to simplify db queries. However, I get error when trying to run a stored procedure. Error message is: Query must start with select

Is that only for the Extensions Creator App? I hope it is still possible to run stored procedures to databases.

Anyone else having issues with stored procedures?

Re: Custom Extensions Creator - use Stored procedures

DynaWiz — Mon, 14 Oct 2024 12:11:28 GMT

Dear @holst

You didn't give detailed information about your query.
Maybe you can use procedure in SELECT statement:
sql - How to SELECT FROM stored procedure - Stack Overflow

SELECT * INTO #tmp FROM OPENQUERY(YOURSERVERNAME, 'EXEC MyProc @parameters')

Best Regards

Michał

Re: Custom Extensions Creator - use Stored procedures

Peter_Youssef — Mon, 14 Oct 2024 17:52:31 GMT

Hello @holst

feel free to review attached URLs for more info:

KR,

Peter.