获得某一节点的所有子节点的自定义函数

CREATE  function f_GetChildOID(@POID varchar(40))
RETURNS @TEMP TABLE(OID VARCHAR(40))
AS
BEGIN
INSERT INTO @TEMP
 SELECT OID
 FROM TBL_SALEORG
 WHERE PARENTOID=@POID AND SOG_STATUS='usage'
WHILE @@ROWCOUNT>0
 INSERT @TEMP
  SELECT A.OID
  FROM TBL_SALEORG A INNER JOIN @TEMP B ON A.PARENTOID=B.OID
  WHERE A.OID NOT IN(SELECT OID FROM @TEMP) AND SOG_STATUS='usage' 
RETURN
END