How can I access stored procedures with result sets?
The SQL CLI fully supports stored procedures with result sets. The easiest example is the stored procedure with a single result set. In the following example, it is assumed that the stored procedure has already been created and registered on the system. This would be accomplished using the CREATE PROCEDURE statement in SQL.
