ALTER FUNCTION [vainimarketing].[dbo.Countnode](@node AS varchar(50)) Returns INT AS BEGIN Declare @lnode Varchar(50) Declare @rnode Varchar(50) Declare @result INT Select @lnode=LeftChild,@rnode=RightChild From Tree where ParentId=@node; if(@lnode=0 AND @rnode=0) begin Set @result=1; end else begin set @result=1+(dbo.Countnode(@lnode)+dbo.Countnode(@rnode)); end return @result; END
set @lcount= vainimarketing.dbo.Countnode(@lchild); set @rcount= vainimarketing.dbo.Countnode(@Rchild);
select @lcount= vainimarketing.dbo.Countnode(@lchild); select @rcount= vainimarketing.dbo.Countnode(@Rchild);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)