递归查询 meaning in English
recursive query
Examples
- A recursive cte can greatly simplify the code required to run a recursive query within a select , insert , update , delete , or create view statement
递归cte可以极大地简化在select 、 insert 、 update 、 delete或create view语句中运行递归查询所需的代码。 - A recursive cte can greatly simplify the code needed to execute a recursive query within a select , insert , update , delete , or create view statement
递归cte极大地简化了需要在select 、 insert 、 update 、 delete或create view语句中执行递归查询的代码。 - Uses a recursive query common table expression to generate a multilevel bill of material : all level 1 components of a level 0 assembly , all level 2 components of a level 1 assembly , and so on
Dbo . uspgetbillofmaterials使用递归查询（公用表表达式）来生成多级物料清单：级别0部件的所有级别1组件，级别1部件的所有级别2组件，等等。 - When testing the results of a recursive query , you can limit the number of recursion levels allowed for a specific statement by using the maxrecursion hint and a value between 0 and 32 , 767 in the option clause of the insert , update , delete , or select statement
在测试递归查询的结果时，可以通过在insert 、 update 、 delete或select语句的option子句中使用maxrecursion提示和0到32 , 767之间的值，来限制特定语句允许的递归级数。 - This paper makes researches on pdm ' s kernel function - pcm ( product configuration management ) under the conditions of autocad and low - price dbms witch could be acceptable in our middle or small factories . this paper mainly discusses the recursive query algorithm based on general database witch is offered in oracle , the problem of the automatic bom maker for autocad and conversion from bom to product structure trees . thus the data of autocad files could go into erp ( enterprise resource plan )
本文从pdm理念出发，在我国中小企业普遍能接受的autocad和低价位数据库管理系统的平台条件下，对pdm的核心技术模块pcm (产品结构管理)的实现进行了研究，重点解决了在一般数据库中实现数据库系统oracle中具备的递归查询算法， autocad环境下bom表的自动生成技术，以及bom表向产品结构树的转化问题，从而使cad数据通过bom表的桥梁作用进入erp (企业资源计划)系统。