sqlserver2005 递归查询
摘要:
从下往上搜索:递归查询 with jdcpclCTE(zj_gch,gch,ilayer) as ( select zj_gch,gch,ilayer=1 from utmis.dbo.jdcpcl where zj_gch>'' and zj_gch='SB07334' union all select a.zj_gch,a.gch,ilayer=ilayer+1 fro... 阅读全文
posted @ 2007-12-21 14:57 金大侠 阅读(483) 评论(3) 推荐(0) 编辑