摘要： /**递归删除菜单**/if exists (select * from sysobjects where name='proc_menu_P_delete')drop proc proc_menu_P_deletegocreate proc proc_menu_P_delete(@id int)as declare @count int,@tmpid int,@err intselect @count=count(1) from tb_menu where pId=@id--通过父Id获得子集数据if(@count>0)--判断是否存在子集数据begin --根据父Id 阅读全文