摘要： 方式一：适用SQL2000+ 1 if object_id('sp_GetAllChild')>0 2 drop proc sp_GetAllChild 3 go 4 5 create proc sp_GetAllChild(@pid varchar(20)) 6 as 7 begin 8 create table #t(ID int,Parent_ID int,Name varchar(1000),level int) 9 declare @t_id varchar(1000),@l int10 set @t_id=@pid11 set @l=012 insert in 阅读全文