CREATE function [dbo].[Get_DepChildren] ( @ID int ) , ),PID ), Name )) as begin --declare @ID Int --set @ID=71 --declare @Tree Table (AID Int,pid Int, fid Int,sn Varchar(200), Name Varchar(200)) Insert @Tree Select pid, fid, sn, Name From tbDepList W