Sidebar

How to call a stored procedures in QIE?

0 votes
118 views
asked Jul 20, 2021 by rich-c-2789 (15,580 points)
How can I call stored procedures in QIE?

1 Answer

0 votes
 
Best answer

As of QIE version .51 additional support has been added to call stored procedures.

- Added support for calling stored procedures that do not use SET NOCOUNT ON

- Added support for calling stored procedures that return multiple result sets.

 

For examples and additional details see these questions:

Recommendations calling MSSQL stored procedures without SET NOCOUNT ON?

What is the difference between the CALL keyword and the EXEC keyword to call a stored procedure?

 

Examples escaping curly braces (used when calling stored procedures):

How to escape curly braces in QIE?

How to escape curly braces when calling stored procedures?

 

Examples calling stored procedures:

Using a Stored Procedure with No Parameters in QIE?

Using a Stored Procedure with Input Parameters in QIE?

Using a Stored Procedure with Output Parameters in QIE?

Using a Stored Procedure with a Return Status in QIE?

Using a Stored Procedure with an Update Count in QIE?

Using a Stored Procedure that Returns Multiple Result Sets in QIE?

answered Jul 20, 2021 by rich-c-2789 (15,580 points)
edited 1 day ago by rich-c-2789
...