但是，如果使用任意数量的表和字段动态地指定from子句或result子句，就不能这样了，因为在编程时无法确定结果集类型。
This no longer works if you use arbitrary tables and fields to specify the from clause or the result clause dynamically, though, because the result set types cannot be determined at programming time.
这样的结果集可以看作是“视图”，它们不是显式地在数据库中创建的，而是由存储过程动态地创建的。
Such result sets can be regarded as "views" that are not explicitly created in the database but are created on the fly by the stored procedure.
MQT是通过select语句定义的(通常是一个结果集)，这样就不需要在执行查询时动态地构建这个结果集。
An MQT is defined by way of a SELECT statement-usually a result set that would otherwise have to be dynamically built when a query executes. Here are three great things about an MQT.
它会动态地缓存内存中的结果集，从而减轻执行“Select”操作的查询和存储过程的负载，进而减少读取操作的反应时间以及总体上的数据库负载。
It offloads the read queries and stored procedures which perform "Select" by dynamically caching in-memory result sets, thereby reducing read response time and overall database load.
结果表明，锡偶联型S-SBR是一种集较佳的静态性能、优异的动态性能、令人满意的安全及低能耗性为一体的新型胎面材料。
The results show that S-SBR has the better physical mechanical properties, excellent dynamic properties, satisfactory wet grip and low rolling energy loss.
动态集是查询的结果，为查询数据库的数据提供索引视图。
A dynaset is the result of a query that provides an indexed view into the queried database's data.
油气藏的形成是静态生油层、储集层、盖层、圈闭组合形态，与动态油气运聚时间、空间上的有利匹配的结果。
Oil deposit or oil field is a result of association of forming time with spatial distribution of source bed, reservoir, trap, migration and entrapment in petroleum system.
油气藏的形成是静态生油层、储集层、盖层、圈闭组合形态，与动态油气运聚时间、空间上的有利匹配的结果。
Oil deposit or oil field is a result of association of forming time with spatial distribution of source bed, reservoir, trap, migration and entrapment in petroleum system.
应用推荐