| 1. | Recursive queries using common table expressions >使用公用表表达式的递归查询 |
| 2. | Create a recursive query 创建递归查询。 |
| 3. | In sql server 2005 , a query is referred to as a recursive query when it references a recursive cte 在sql server 2005中,当某个查询引用递归cte时,它即被称为“递归查询” 。 |
| 4. | Using a cte allows the use of recursive queries and can simplify logic by replacing the use of temporary tables or views 利用cte ,可使用递归查询并可通过取代临时表或视图来简化逻辑。 |
| 5. | The transact - sql language has been extended with features such as improved error handling and support for recursive queries Transact - sql语言得到了扩展,例如,改进了错误处理功能,支持递归查询。 |
| 6. | Uses a recursive query common table expression to return the direct and indirect employees of the specified manager Dbo . uspgetmanageremployees使用递归查询(公用表表达式)来返回指定经理的直接和间接下属。 |
| 7. | Uses a recursive query common table expression to return the direct and indirect managers of the specified employee Dbo . uspgetemployeemanagers使用递归查询(公用表表达式)来返回指定雇员的直接和间接上司。 |
| 8. | Uses a recursive query common table expression to return all product assemblies that use the specified product component Dbo . uspgetwhereusedproductid使用递归查询(公用表表达式)来返回使用指定产品组件的所有产品部件。 |
| 9. | In earlier versions of sql server , a recursive query usually requires using temporary tables , cursors , and logic to control the flow of the recursive steps 在sql server的早期版本中,递归查询通常需要使用临时表、游标和逻辑来控制递归步骤流。 |
| 10. | 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语句中运行递归查询所需的代码。 |