摘要： 方法一：DECLARE @employeeid INT;set @employeeid = 8115;DECLARE @id INT;DECLARE @pid int;DECLARE @level int;SET @id=-1--获取父节点idSELECT @id = RecID, @pid = P... 阅读全文