Shulou(Shulou.com)05/31 Report--

How to implement recursive query in sql server? in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Sql server supports recursive queries through CTE, which is useful for querying tree or hierarchical data

The general tree table structure is as follows, which I believe we are all familiar with.

Level 1 Node 0 2 level 2 Node 1 3 level 3 Node 2 4 level 4 Node 3 level 5 Node 4

The following is the code

-sql server recursive query-find all superior nodes with uCte as (select a. ID. Title.pid from tree_table a where id = 3muri-current node union all select k.idjen k.title.pi from tree_table k inner join uCte c on c.pid = k.id) select * from uCte -- find all the superior node with dCte as (select a. ID. Title. Title. Pid from tree_table a where id = 3-current node union all select k.idmage k. Title. Pid from tree_table k inner join dCte c on c.id = k.pid) select * from dCte This is the answer to the question about how to implement recursive query in sql server. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.