摘要:
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. 阅读全文