与读数据库打开“执行存储过程ator"

EMDuell

Hello,

I'm attempting to execute a stored procedure with the Read Database operator and I receive an error, saying "executeQuery only accepts the SELECT statement".

Is there a special technique I need to use to pass parameters to a stored procedure so that I can read the results into an example set? I thought about the the Execute SQL operator, but that won't work.

Thanks for the help..code below.

-Eric

---

@Resource=Trends"/>;

BalazsBarany

Does your function return a table structure? If it does, try wrapping it in a SELECT query:

SELECT *
FROM (
EXEC GetRemainingRequests@Resource=Trends
)

There is also an Execute SQL operator for calling arbitrary functions but it doesn't return an example set.