SQL 无限极分类获取子节点分类的SQL
摘要:
1、创建函数方法create function GetCategoryChilds(@id int) returns @category TABLE (ID int,Level int)asBEGINDECLARE @level intset @level = 1insert @category select @id,@levelWHILE @@ROWCOUNT>0BEGINSET @lev... 阅读全文
posted @ 2010-07-18 22:12 dream one minute 阅读(671) 评论(0) 推荐(0) 编辑