获取一个存储过程返回的结果集。
这一示例没有从存储过程返回任何东西。
This example does not return anything back from the stored procedure.
如何处理存储过程返回的数据？
How do you handle the data that is returned from a stored procedure?
如何处理存储过程返回的异常？
How do you handle the exception that is returned from a stored procedure?
改进了对数据库存储过程返回的结果集的支持。
Improved support for result sets returned by database stored procedures.
该增强也允许基于CLR的存储过程返回多个结果集。
This enhancement also enables CLR-based stored procedures to return multiple results sets too.
如果远程过程返回多个结果集，那么其他结果集被丢弃。
If the remote procedure returns more than one result set, the remaining result sets are discarded.
要从一个SQL过程返回一个结果集，执行以下步骤。
To return a result set from an SQL procedure, do the following.
从过程返回的值可以像变量或常数的值一样参与到表达式中。
The value returned from the procedure participates in the expression just as the value of a variable or constant would.
在执行该语句时处理将立即停止，而过程返回给调用者的代码是SQLERROR的值。
Processing stops immediately when this statement is executed, and the procedure return code to the caller is the value of SQLERROR.
这些从关联模型中提取出来的规则由此存储过程返回并导入到Cognos作为查询主题。
The extracted rules of the association models are returned by the stored procedure and imported into Cognos as query subjects.
根据SybStockQuote过程返回的股票报价，用股票数量乘以股票报价计算出市值。
Based on the stock quote returned from procedure SybStockQuote, it calculates the market value by multiplying the number of shares with the stock quotes.
本文描述的是在Sybase存储过程返回一个单独的结果集的情况下，可用来解决上述问题的另一种方法。
This article describes yet another approach that is available if the Sybase stored procedure returns a single result set.
在过程返回后，有效权限将恢复为当前用户的权限，它仍然可以查看临时表并对其执行任何操作。
After the procedure returns, the effective privileges revert to those of the current user, which can still see the temporary table and perform any operation on it.
您将会看到，我使用的就是技巧1中讨论的理念，从一个存储过程返回两个结果集：记录的总数和请求的数据。
You'll see that I am using the ideas discussed in Tip 1, returning two resultsets from one stored procedure: the total number of records and the requested data.
JDBC应用程序以ResultSet对象的形式从联邦存储过程或远程本地存储过程返回结果集。
The JDBC application returned these as a ResultSet object from either the federated stored procedure or the remote native stored procedure.
如果远程过程返回不受支持的结果集类型，比如lob或XML，那么CALL返回错误SQL 3324n。
If the remote procedure returns an unsupported result set type, such as LOB or XML, the CALL returns error SQL3324N.
这个表空间用来容纳 ADMIN_COPY_SCHEMA过程所使用的元数据以及这个过程返回的错误表。
This table space is used to hold metadata used by the ADMIN_COPY_SCHEMA procedure as well as error tables returned by this procedure.
t2zos不知道从存储过程返回的游标是不是一个行集，因此t2zos驱动程序仅允许对存储过程执行单行获取。
T2zos does not know if the cursor returned from a stored procedure is rowset or not, thus the t2zos driver allows only single row fetch for a stored procedure.
在这两种情况下测出的时间开销相当接近，与本地存储过程相比，联邦存储过程返回的每行的时间开销实际上要低一些。
Elapsed time measured in both cases was quite close, with the elapsed time per row returned by the federated stored procedure actually somewhat less than that of the native stored procedure.
该过程返回一个简单的结果集，其中包含一个SQLvarchar列(用于客户的姓名)和一个xml列(用于客户电子邮件)。
This procedure returns a single result set that contains a SQL VARCHAR column (for the client's name) and an XML column (for the client's email). The query will be similar to the following.
在接下来的例子中，字符串'hello '被传递给存储过程，当存储过程返回时，hello被替换为该存储过程返回的值。
In this next example, the string 'hello' is passed into the stored procedure, and when it returns, hello is replaced with the return value of the procedure.
存储过程可以返回零个或更多的结果集，每个结果集由一组行组成。
Stored procedures can return zero or more result sets, each consisting of a set of rows.
注意，一旦存储过程成功返回，它就会使用补偿框架注册。
Notice that once the stored procedure returns successfully it registers with the compensation framework.
联邦过程只返回第一个结果集。
实验设置与前面的测试相同，惟一不同的是远程存储过程现在返回一个结果集，结果集的大小取决于输入参数。
Our experimental setup was the same as for the last tests, except that the remote stored procedure was written to return a result set whose size depended on an input parameter.
错误处理：新的存储过程现在返回带有适当SQLCODE和SQLSTATE的SQLCA，在使用SQL时与错误处理框架更加内联。
Error handling: the new stored procedure now returns SQLCA with proper SQLCODE and SQLSTATE that is more inline with the error handling framework when using SQL.
这个选项决定过程将返回多少结果集。
This option will determine how many result sets the procedure is going to return.
存储过程也可能返回多个结果集。
It is possible that a stored procedure can return multiple result sets as well.
注意，所有与列表相关的过程也返回它们刚才修改的列表，因此您可能这样编写代码。
Note that all list-related procedures also return the list they've just modified, so you could write.
应用推荐