摘要: ALTER FUNCTION UFun_GetChildren(@ID nvarchar(60))RETURNS @tbChildren TABLE (ID varchar(60) )ASBEGIN WITH UFun_GetChildren(ID) AS ( SELECT OrganizationID FROM ECOrganization WHERE ParentOrganizationID=@ID UNION ALL SELECT OrganizationID FROM ECOrganization INNER JOIN UFun_GetChildren ON UFun_GetChil. 阅读全文
posted @ 2012-08-03 17:26 万德源 阅读(1715) 评论(0) 推荐(0) 编辑