结果:
--游标效率太差,万不得已不要使用,SQLServer2005的apply运算符可以替代它
SELECT *
FROM Departments AS D
CROSS APPLY fn_getsubtree(D.deptmgrid) AS ST
FROM Departments AS D
OUTER APPLY fn_getsubtree(D.deptmgrid) AS ST
结果:
===================================================
最后一行数据体现出CROSS APPLY和OUTER APPLY的不同,这有点类似Inner join和left join的区别.