maxiaozhi8的博客

原创 sql递归到指定层级后停止

sqlserver递归中断,超过递归数返回null(设置50层)，默认递归最大循环100 CREATE FUNCTION [dbo].[getLevel](@id varchar(100)) RETURNS int AS BEGIN declare @level int; with cte(id,pid,[level]) as ( select i...