Back to OIM Explorer

dbo.ADS_FTDomainTree

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 1.121 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

  • No direct source references extracted.

Complete Source

SQL55 lines
1CREATE FUNCTION dbo.ADS_FTDomainTree(2  @UID_ADSDomain varchar(38)3) RETURNS @sammel TABLE(Ident_Domain nvarchar(64) collate database_default,4UID_ADSDomain varchar(38) collate database_default primary key(UID_ADSDomain)5)6  WITH schemabinding7AS8BEGIN9  INSERT INTO @sammel(Ident_Domain,10  UID_ADSDomain)11  SELECT12    ident_domain,13    @UID_ADSDomain14  FROM dbo.ADSDomain15  WHERE16    UID_ADSDomain = @UID_ADSDomain17  DECLARE @lauf int = 118  WHILE @lauf > 019  BEGIN20    INSERT INTO @sammel(Ident_Domain,21    UID_ADSDomain)22    SELECT23      DISTINCT p.Ident_Domain,24      p.UID_ADSDomain25    FROM dbo.ADSDomain d26    JOIN @sammel s27      ON d.UID_ADSDomain = s.UID_ADSDomain28    JOIN dbo.ADSDomain p29      ON d.UID_ADSDomainParent = p.UID_ADSDomain30    WHERE31      NOT EXISTS(32    SELECT TOP 1 133    FROM @sammel e34    WHERE35      e.UID_ADSDomain = p.UID_ADSDomain)36    SELECT @lauf = @@ROWCOUNT37    INSERT INTO @sammel(Ident_Domain,38    UID_ADSDomain)39    SELECT40      DISTINCT d.Ident_Domain,41      d.uid_adsdomain42    FROM dbo.ADSDomain d43    JOIN @sammel s44      ON d.UID_ADSDomainParent = s.UID_ADSDomain45    WHERE46      NOT EXISTS(47    SELECT TOP 1 148    FROM @sammel e49    WHERE50      e.UID_ADSDomain = d.UID_ADSDomain)51    SELECT @lauf += @@ROWCOUNT52  END53  endLabel:54  RETURN55END
Open raw exported source
SQL ยท Raw9 lines
1create function dbo.ADS_FTDomainTree (@UID_ADSDomain varchar(38) ) returns @sammel table (Ident_Domain nvarchar(64) collate database_default , UID_ADSDomain2 varchar(38) collate database_default primary key (UID_ADSDomain) ) with schemabinding as begin insert into @sammel(Ident_Domain, UID_ADSDomain) select3 ident_domain, @UID_ADSDomain from dbo.ADSDomain where UID_ADSDomain = @UID_ADSDomain declare @lauf int = 1 while @lauf > 0 begin insert into @sammel (Ident_Domain4, UID_ADSDomain) select distinct p.Ident_Domain, p.UID_ADSDomain from dbo.ADSDomain d join @sammel s on d.UID_ADSDomain = s.UID_ADSDomain join dbo.ADSDomain5 p on d.UID_ADSDomainParent = p.UID_ADSDomain where Not exists(select top 1 1 from @sammel e where e.UID_ADSDomain = p.UID_ADSDomain ) select @lauf = @@ROWCOUNT6 insert into @sammel (Ident_Domain, UID_ADSDomain) select distinct d.Ident_Domain, d.uid_adsdomain from dbo.ADSDomain d join @sammel s on d.UID_ADSDomainParent7 = s.UID_ADSDomain where Not exists(select top 1 1 from @sammel e where e.UID_ADSDomain = d.UID_ADSDomain ) select @lauf += @@ROWCOUNT end endLabel: return8 end 9