语句被终止。完成执行语句前已用完最大递归 100

sql语句递归查询会员的推荐或安置关系时报错：语句被终止。完成执行语句前已用完最大递归……

服务器范围的默认值为 100。如果指定 0，则没有限制。每一个语句只能指定一个 MAXRECURSION 值使用类似的语句：

例如：

USE AdventureWorks2008R2;
GO
--Creates an infinite loop
WITH cte (EmployeeID, ManagerID, Title) as
(
    SELECT EmployeeID, ManagerID, Title
    FROM dbo.MyEmployees
    WHERE ManagerID IS NOT NULL
  UNION ALL
    SELECT cte.EmployeeID, cte.ManagerID, cte.Title
    FROM cte 
    JOIN  dbo.MyEmployees AS e 
        ON cte.ManagerID = e.EmployeeID
)
--Uses MAXRECURSION to limit the recursive levels to 2
SELECT EmployeeID, ManagerID, Title
FROM cte
OPTION (MAXRECURSION 2);
GO

 

文章参考：http://bbs.csdn.net/topics/390412714