Back to OIM Explorer

dbo.ADS_FGIDomainTrustExists

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.000 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

SQL37 lines
1CREATE FUNCTION dbo.ADS_FGIDomainTrustExists(2  @UID_ADSDomainMember varchar(38),3  @UID_ADSDomainGroup varchar(38)4) RETURNS int5  WITH schemabinding6AS7BEGIN8  DECLARE @Erg int = 09  IF EXISTS(10    SELECT TOP 1 111    FROM dbo.DomainTrustsDomain dd12    WHERE13      dd.UID_ADSDomainTrusts = @UID_ADSDomainGroup AND dd.UID_ADSDomainTrusted = @UID_ADSDomainMember)14  BEGIN15    SELECT @Erg = 116    RETURN(@erg)17  END18  IF EXISTS(19    SELECT TOP 1 120    FROM dbo.DomainTrustsDomain dd21    JOIN dbo.ADSDomain e222      ON e2.UID_ADSDomain = dd.UID_ADSDomainTrusts23    JOIN dbo.ADSDomain t124      ON dd.UID_ADSDomainTrusted = t1.UID_ADSDomain25    JOIN dbo.ADSDomain e126      ON e1.UID_ADSForest = e2.UID_ADSForest OR e1.UID_ADSDomain = e2.UID_ADSDomain27    JOIN dbo.ADSDomain t228      ON t1.UID_ADSForest = t2.UID_ADSForest OR t1.uid_adsdomain = t2.UID_ADSDomain29    WHERE30      e1.UID_ADSDomain = @UID_ADSDomainGroup AND t2.UID_ADSDomain = @UID_ADSDomainMember AND e1.UID_ADSDomain <> t2.UID_ADSDomain)31  BEGIN32    SELECT @Erg = 233    RETURN(@erg)34  END35  endLabel:36  RETURN(@erg)37END
Open raw exported source
SQL ยท Raw8 lines
1  create   function dbo.ADS_FGIDomainTrustExists(@UID_ADSDomainMember varchar(38) , @UID_ADSDomainGroup varchar(38) ) returns int with schemabinding2 as begin declare @Erg int = 0     if exists (select top 1 1 from dbo.DomainTrustsDomain dd   where dd.UID_ADSDomainTrusts = @UID_ADSDomainGroup and dd.UID_ADSDomainTrusted3 = @UID_ADSDomainMember ) begin select @Erg = 1  return (@erg)  end   if exists (select top 1 1 from dbo.DomainTrustsDomain dd join dbo.ADSDomain e2 on4 e2.UID_ADSDomain = dd.UID_ADSDomainTrusts join dbo.ADSDomain t1 on dd.UID_ADSDomainTrusted = t1.UID_ADSDomain join dbo.ADSDomain e1 on  e1.UID_ADSForest5 = e2.UID_ADSForest or e1.UID_ADSDomain = e2.UID_ADSDomain join dbo.ADSDomain t2 on  t1.UID_ADSForest = t2.UID_ADSForest or t1.uid_adsdomain = t2.UID_ADSDomain6 where e1.UID_ADSDomain = @UID_ADSDomainGroup and t2.UID_ADSDomain = @UID_ADSDomainMember and e1.UID_ADSDomain <> t2.UID_ADSDomain ) begin select @Erg 7= 2  return (@erg)  end endLabel: return (@erg) end 8