Back to OIM Explorer

dbo.TSB_FGIGroupAccountMatching

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

Complete Source

SQL31 lines
1CREATE FUNCTION dbo.TSB_FGIGroupAccountMatching(2  @matchPatternAccount bigint,3  @matchPatternGroup bigint4) RETURNS int5  WITH SCHEMABINDING6AS7BEGIN8  DECLARE @matchPatternAccount_intern bigint9  DECLARE @matchPatternGroup_intern bigint10  DECLARE @erg int11  IF isnull(@matchPatternAccount,12  0) = 013  BEGIN14    SELECT @matchPatternAccount_intern = 0x7fffffffffffffff15  END16  ELSE17  BEGIN18    SELECT @matchPatternAccount_intern = @matchPatternAccount19  END20  IF isnull(@matchPatternGroup,21  0) = 022  BEGIN23    SELECT @matchPatternGroup_intern = 0x7fffffffffffffff24  END25  ELSE26  BEGIN27    SELECT @matchPatternGroup_intern = @matchPatternGroup28  END29  SELECT @erg = sign(@matchPatternGroup_intern & @matchPatternAccount_intern) ende:30  RETURN(@erg)31END
Open raw exported source
SQL · Raw6 lines
1  create   function dbo.TSB_FGIGroupAccountMatching ( @matchPatternAccount bigint, @matchPatternGroup bigint ) returns int with SCHEMABINDING as2 begin  declare @matchPatternAccount_intern bigint declare @matchPatternGroup_intern bigint declare @erg int if isnull(@matchPatternAccount, 0) = 0 begin3  select @matchPatternAccount_intern = 0x7fffffffffffffff end else begin select @matchPatternAccount_intern = @matchPatternAccount end if isnull(@matchPatternGroup4, 0) = 0 begin select @matchPatternGroup_intern = 0x7fffffffffffffff end else begin select @matchPatternGroup_intern = @matchPatternGroup end select @erg5 = sign(@matchPatternGroup_intern & @matchPatternAccount_intern) ende: return(@erg) end 6