Back to OIM Explorer

dbo.QBM_FGIModuleLower

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL23 lines
1CREATE FUNCTION dbo.QBM_FGIModuleLower(2  @Module1 varchar(3),3  @Module2 varchar(3)4) RETURNS varchar(35)6AS7BEGIN8  DECLARE @erg varchar(3)9  IF EXISTS(10    SELECT TOP 1 111    FROM dbo.QBMModuleDependCollection co12    WHERE13      co.UID_ModulePredecessor = @Module1 + '-Moduledefinition' AND co.UID_ModuleFollower = @Module2 + '-Moduledefinition')14  BEGIN15    SELECT @erg = @Module116  END17  ELSE18  BEGIN19    SELECT @erg = @Module220  END21  endLabel:22  RETURN(@erg)23END
Open raw exported source
SQL ยท Raw4 lines
1  create   function dbo.QBM_FGIModuleLower (@Module1 varchar(3) , @Module2 varchar(3) ) returns varchar(3)   as begin declare @erg varchar(3) if2 exists (select top 1 1 from dbo.QBMModuleDependCollection co where co.UID_ModulePredecessor = @Module1 + '-Moduledefinition' and co.UID_ModuleFollower3 = @Module2 + '-Moduledefinition' ) begin select @erg = @Module1 end else begin select @erg = @Module2 end endLabel: return(@erg) end 4