开发者

How many maximum recursion possible for CTE in SQL server?

开发者 https://www.devze.com 2022-12-27 03:56 出处:网络
How many maximum recursion level possible for CTE in SQL server? If maximum recursion level is reached then what are th开发者_开发问答e alternative way?By default, it\'s 100.

How many maximum recursion level possible for CTE in SQL server? If maximum recursion level is reached then what are th开发者_开发问答e alternative way?


By default, it's 100.

You can change it on per-query basis by appending a hint:

OPTION (MAXRECURSION N)

to the end of the query.

OPTION (MAXRECURSION 0)

means no explicit limit.

When the recursion limit is reached, an error is raised and the query breaks.

0

精彩评论

暂无评论...
验证码 换一张
取 消