T-SQL with关键字 with as 递归循环表
摘要：
DECLARE @OrgId nvarchar(36)SET @OrgId = N'901205CA-6C22-4EE7-AE4B-96CC7165D07F'; WITH Childs AS ( SELECT * FROM HROrgRelation WHERE ParentNM = @OrgId UNION ALL SELECT A.* FROM HROrgRelation A, Chi... 阅读全文
posted @ 2017-07-26 10:54 _ali 阅读(175) 评论(0) 推荐(0) 编辑
