MS SQL Server树型结构数据显示的SQL语句(纯SQL语句,不用函数)
摘要:
SELECT dpcode1+dpcode2+dpcode3 as 部门代码,dpname1+dpname2+dpname3 as 部门名称 FROM T_Dpt where dpname1 is not null and dpname2 is not null and dpname3 is not null union all SELECT dpcode1+dpcode2+dpcode3 as... 阅读全文
posted @ 2005-11-26 17:15 Double_ 阅读(973) 评论(0) 推荐(0) 编辑