How to call a stored procedures in QIE?

Question

How can I call stored procedures in QIE?

Answer 1

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?