摘要： create procedure pro_delete@deleteId intasdeclare @nodeid intdeclare @id intdeclare @pid intset @nodeid = @deleteIdset @id = @nodeidset @pid = @nodeidbegin transactionwhile(exists (select * from H where id = @nodeid))begin if(exists (select * from H where Pid = @id and id != @id) ) begin set @pid = 阅读全文