SQL server based-CodePudding

With t as (select * from a where ID=2
Union all
Select * from t. t inner join a
On t.I D=Anderson D)
Select * from t;
The specific operation steps?
Why tip: message 530, level 16, state 1, line 1
Statement is terminated, before completing the statement execution has been finished with maximum recursion 100,
Results also show 202 rows

CodePudding user response:

With t, and inside the select * from t. t, what is this you have a recursive query

CodePudding user response:

 with t as (select * from a where ID=2 
Union all 
Select * from t. t inner join a 
On t.I D=Anderson D) 
Select * from t OPTION (MAXRECURSION 0);