Shulou(Shulou.com)06/02 Report--

In this issue, the editor will bring you about the use of recursion in With As in SQL Server. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

Let's talk about the use of recursion.

Code demonstration

Generally speaking, we use recursion through UNION ALL. Under UNION ALL, you can directly refer to the name of the with as we defined, as follows:

In the picture above, we simply list the arrangement of numbers within 100, and the complete code.

Declare @ count intselect @ count=1with tb as (select number= @ count union all select number=tb.number+1 from tb where tb.number+1

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.