sqlserver递归相应的Id

数据库 sqlserver 递归所有旗下分类 其中把参数 设定在 @UserID中。然后从 cte的表中获取到对应的Id
declare @UserID int;
set @UserID =1;
WITH cte AS
(
SELECT a.Id,0 AS lvl FROM TypeInfo a WHERE a.pid=@UserID
UNION ALL
SELECT a.Id,1+lvl FROM TypeInfo a INNER JOIN cte c ON a.Pid=c.Id
)
SELECT * INTO #Temp FROM cte