摘要: 使用CTE查询递归层级:(Sql CTE Recursion) 1 WITH CTE_MA AS 2 ( 3 SELECT 0 AS Tier, EmployeeID, ManagerID, FirstName, LastName 4 FROM dbo.MyEmployees 5 ... 阅读全文
posted @ 2015-01-08 17:03 Thirty 阅读(283) 评论(0) 推荐(0) 编辑