随笔分类 -  SQL Server

SQL SERVER with递归示例一则
摘要：1 WITH SUBQUERY AS ( 2 SELECT 3 ORGID 4 FROM 5 OM_ORGANIZATION 6 WHERE 7 PARENTORGID = 'ROOT' 8 UNION ALL 9 SELECT 10 B.ORGID 11 FROM 12 SUBQUERY A, 1 阅读全文
posted @ 2016-03-03 09:17 剑握在手 阅读(240) 评论(0) 推荐(0) 编辑

返回顶部↑
点击右上角即可分享
微信分享提示