摘要:
CREATE PROCEDURE [dbo].[GetRootID](@nodeID varchar(36))ASBEGINSET NOCOUNT ON; DECLARE @rootID varchar(36), @currentID varchar(36) SELECT @rootID = ParentOrgID, @currentID = @nodeID FROM Organization WHERE OrgID = @nodeID; WHILE @rootID !='0' BEGIN SELECT @rootID = ParentOrgID, @currentID = O 阅读全文
摘要:
CREATE function [dbo].[GetChildOrgID](@OrgID varchar(36)) returns @t table(OrgID varchar(36),ParentOrgID varchar(36),Level int) as begin declare @i int set @i = 1 insert into @t select @OrgID,@OrgID,0 --当前级,本级,如果不要的话可以注释掉或再加个参数来选择操作 insert into @t select OrgID,ParentOrgID,@i from SM_Organization... 阅读全文