SQL Server查找一棵树
摘要：
WITH ModuleInfo AS(select * from Base_Module where Code='HRAdmin'UNION ALLselect a.* from Base_Module AS a,ModuleInfo AS b WHERE a.parentid = b.id and a.Enabled=1 and a.DeletionStateCode=0)SELECT * FROM ModuleInfoorder by SortCode 阅读全文
posted @ 2012-02-27 15:22 nick轩 阅读(227) 评论(0) 推荐(0) 编辑