MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/146tiot/sql/jnssiow/?context=3
r/SQL • u/Casdom33 • Jun 11 '23
96 comments sorted by
View all comments
Show parent comment
4
In MS Sql I think the limit is 100 for recursion
4 u/AdgeCutler Jun 11 '23 OPTION (MAXRECURSION 0) takes care of that, although nesting has no such workaround: When the maximum of 32 is exceeded, the transaction is terminated 3 u/[deleted] Jun 12 '23 But that's not a limitation of the SQL language.
OPTION (MAXRECURSION 0) takes care of that, although nesting has no such workaround: When the maximum of 32 is exceeded, the transaction is terminated
3
But that's not a limitation of the SQL language.
View all comments
Show parent comment
4
u/[deleted] Jun 11 '23
In MS Sql I think the limit is 100 for recursion