摘要:
MSSQL获取父节点方法CREATE FUNCTION [dbo].[Fn_GetSelfParentNodes] ( @NodeID bigint,--当前节点编号 @IsContainSelf bit--是否包含当前节点)RETURNS @Table TABLE ( NodeID bigint, NodeLevel int)ASBEGINIF @NodeID <=0BEGIN RETURN --无法节点ENDDeclare @CID bigintDeclare @level int if(@IsContainSelf=0)--不包含当前节点 ... 阅读全文