通过从昵称中进行选择,我们也可以来查看存储过程的结果集。
We can also see the result set of the store procedure by selecting from the nickname.
它们可以是基表或者中间结果集。
首先介绍结果集的分页和排序。
指定可能返回的结果集的最大数量。
Specify the maximum possible number of result sets likely to be returned.
执行这个预定义语句获取一个结果集。
查询的结果集将被传递给这个处理器。
The result set from the query will be passed to the handler.
select语句和结果集。
返回SQL过程的结果集
分块、存储过程和结果集。
SQL可以有输入参数,可以返回结果集。
The SQL could have input parameters and could return result sets.
希望对结果集进行分页。
游标模型考虑了不对称和大型结果集的情况。
The cursor model takes into account the cases of asymmetry and large result sets.
可能会要求显式捕获选项以减少某些结果集。
The explicit capture option may be required to reduce some resultsets.
结果集是每种规范的结果集的交集。
The resulting set will be the intersection of the resulting sets of each spec.
用户可以查看执行的状态、输出参数和结果集。
Users can view the status of the execution, output parameters, and result set.
正如限制一节中提到的,不支持可持有结果集。
As mentioned in the Limitations section, holdable result sets are not supported.
实际返回的结果集的数量一定不能超过这个数字。
The number of results sets actually returned must not exceed this number.
显然,存储过程不一定非要返回结果集。
Obviously, a stored procedure doesn't have to return a resultset.
不同的数据源在如何实现结果集方面有显著的差异。
The various data sources differ significantly in how they implement result sets.
它会在RAM中按照原样保存数据库返回的结果集。
It stores the result sets returned by the database in RAM, as is.
通过枚举器检索的每个值都应与结果集的一行对应。
Each value retrieved via the enumerator should correspond with one row of the resultset.
结果集最初会被存储在缓存中,随后产生所需的输出。
The result set will initially be stored in the cache to subsequently produce the desired output.
该增强也允许基于CLR的存储过程返回多个结果集。
This enhancement also enables CLR-based stored procedures to return multiple results sets too.
使用分块、存储过程和结果集减少与服务器之间的往返。
Reduce the number of trips to the server with blocking, stored procedures, and result sets.
SQL结果集为处理搜索结果提供了一种方便的机制。
SQL result sets provide a convenient mechanism for working with search results.
如果远程过程返回多个结果集,那么其他结果集被丢弃。
If the remote procedure returns more than one result set, the remaining result sets are discarded.
在选择查询的情况下,将返回描述结果集的对象。
In the case of a select query, objects representing ResultSets will be returned.
我们也可以通过从昵称中进行选择来查看存储过程的结果集。
We can also see the result set of the stored procedure by selecting from the nickname.
执行过程和函数:执行存储过程和函数,并查看生成的结果集。
Execute procedures and functions: Execute stored procedures and functions, and view the returned result sets.
执行过程和函数:执行存储过程和函数,并查看生成的结果集。
Execute procedures and functions: Execute stored procedures and functions, and view the returned result sets.
应用推荐