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 SELECT o.org_i
阅读背景：
sqlserverwith语句
来源：互联网
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 SELECT o.org_i
分享到：
