Back to OIM Explorer

dbo.QBM_FGIModulePrecedenceValid

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 920 characters

Interpretation

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

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVGUIDToModuleOwner source text reference
  • references source dbo.QBM_FCVObjectKeyToModuleOwner source text reference

References

Referenced By

Complete Source

SQL40 lines
1CREATE FUNCTION dbo.QBM_FGIModulePrecedenceValid(2  @ObjectkeyOrGUIDPredecessor varchar(138),3  @ObjectkeyOrGUIDFollower varchar(138)4) RETURNS BIT5AS6BEGIN7  DECLARE @erg BIT = 08  DECLARE @m1 varchar(38)9  DECLARE @m2 varchar(38)10  IF LEN(@ObjectkeyOrGUIDPredecessor) > 3811  BEGIN12    SELECT13      @m1 = dbo.QBM_FCVObjectKeyToModuleOwner(@ObjectkeyOrGUIDPredecessor) + '-Moduledefinition'14  END15  ELSE16  BEGIN17    SELECT18      @m1 = dbo.QBM_FCVGUIDToModuleOwner(@ObjectkeyOrGUIDPredecessor) + '-Moduledefinition'19  END20  IF LEN(@ObjectkeyOrGUIDFollower) > 3821  BEGIN22    SELECT23      @m2 = dbo.QBM_FCVObjectKeyToModuleOwner(@ObjectkeyOrGUIDFollower) + '-Moduledefinition'24  END25  ELSE26  BEGIN27    SELECT28      @m2 = dbo.QBM_FCVGUIDToModuleOwner(@ObjectkeyOrGUIDFollower) + '-Moduledefinition'29  END30  IF EXISTS(31    SELECT TOP 1 132    FROM QBMModuleDependCollection co33    WHERE34      co.UID_ModulePredecessor = @m1 AND co.UID_ModuleFollower = @m2)35  BEGIN36    SELECT @erg = 137  END38  ende:39  RETURN(@erg)40END
Open raw exported source
SQL ยท Raw7 lines
1  create   function dbo.QBM_FGIModulePrecedenceValid( @ObjectkeyOrGUIDPredecessor varchar(138) , @ObjectkeyOrGUIDFollower varchar(138) ) returns2 bit as begin declare @erg bit = 0 declare @m1 varchar(38) declare @m2 varchar(38) if LEN(@ObjectkeyOrGUIDPredecessor) > 38 begin select @m1 = dbo.QBM_FCVObjectKeyToModuleOwner3(@ObjectkeyOrGUIDPredecessor)+ '-Moduledefinition' end else begin select @m1 = dbo.QBM_FCVGUIDToModuleOwner(@ObjectkeyOrGUIDPredecessor)+ '-Moduledefinition'4 end if LEN(@ObjectkeyOrGUIDFollower) > 38 begin select @m2 = dbo.QBM_FCVObjectKeyToModuleOwner(@ObjectkeyOrGUIDFollower)+ '-Moduledefinition' end else5 begin select @m2 = dbo.QBM_FCVGUIDToModuleOwner(@ObjectkeyOrGUIDFollower)+ '-Moduledefinition' end if exists (select top 1 1 from QBMModuleDependCollection6 co where co.UID_ModulePredecessor = @m1 and co.UID_ModuleFollower = @m2 ) begin select @erg = 1 end ende: return(@erg) end 7