iteye_2544的博客

原创 sql server with 语句

递归，用于部门的拼接。 eg： WITH orgs AS ( SELECT o.org_id , o.org_name, o.ORG_PARENT , CAST('/'+ o.ORG_NAME as varchar(4000)) as pname from U_ORG o where o.org_id = 1 union all SELECT s.O...