Custom Extensions Creator - use Stored procedures

[holst]

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?

[michal_lewi · Accepted solution]

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ł

[Peter_Youssef]

Hello @holst 

feel free to review attached URLs for more info:

1. sql-data-source 
2. sql-server 
3. custom-database-extension 

KR, 

Peter.