Back to OIM Explorer

dbo.QBM_FGISessionErrorIsMissingCo

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.484 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_FTSessionErrorLoad source text reference

References

Referenced By

Complete Source

SQL81 lines
1CREATE FUNCTION dbo.QBM_FGISessionErrorIsMissingCo(2  @ErrorBuffer QBM_YSessionError READONLY3) RETURNS int4AS5BEGIN6  DECLARE @erg BIT = 07  DECLARE @BufferIntern QBM_YSessionError8  DECLARE @LastElement int9  IF NOT EXISTS(10    SELECT TOP 1 111    FROM @ErrorBuffer)12  BEGIN13    INSERT INTO @BufferIntern(ErrorMessage,14    ErrorSeverity,15    ErrorState,16    ErrorNumber,17    ProcedureName,18    ProcedureLine,19    MessageDate,20    GenProcID,21    RepeatCounter,22    IsReThrow,23    SourceCode)24    SELECT25      ErrorMessage,26      ErrorSeverity,27      ErrorState,28      ErrorNumber,29      ProcedureName,30      ProcedureLine,31      MessageDate,32      GenProcID,33      RepeatCounter,34      IsReThrow,35      SourceCode36    FROM dbo.QBM_FTSessionErrorLoad() l37    ORDER BY l.RecordNumber38  END39  ELSE40  BEGIN41    INSERT INTO @BufferIntern(ErrorMessage,42    ErrorSeverity,43    ErrorState,44    ErrorNumber,45    ProcedureName,46    ProcedureLine,47    MessageDate,48    GenProcID,49    RepeatCounter,50    IsReThrow,51    SourceCode)52    SELECT53      ErrorMessage,54      ErrorSeverity,55      ErrorState,56      ErrorNumber,57      ProcedureName,58      ProcedureLine,59      MessageDate,60      GenProcID,61      RepeatCounter,62      IsReThrow,63      SourceCode64    FROM @ErrorBuffer65  END66  SELECT @LastElement = MAX(b.ElementIndex)67  FROM @BufferIntern b68  WHERE69    b.IsReThrow = 070  IF EXISTS(71    SELECT TOP 1 172    FROM @BufferIntern b73    WHERE74      b.ElementIndex = @LastElement AND(b.ErrorNumber IN(2812, 4121, 21343) OR b.ErrorMessage LIKE '%Could not find stored procedure%' OR b.ErrorMessage75  LIKE '%Cannot find either%or the user-defined function or aggregate%or the name is ambiguous%'))76  BEGIN77    SELECT @erg = 178  END79  endLabel:80  RETURN(@erg)81END
Open raw exported source
SQL · Raw11 lines
1   create   function dbo.QBM_FGISessionErrorIsMissingCo  (@ErrorBuffer QBM_YSessionError readOnly  ) returns int  as begin declare @erg bit = 0 2declare @BufferIntern QBM_YSessionError declare @LastElement int if not exists (select top 1 1 from @ErrorBuffer ) begin insert into @BufferIntern(ErrorMessage3, ErrorSeverity, ErrorState, ErrorNumber , ProcedureName, ProcedureLine, MessageDate , GenProcID, RepeatCounter, IsReThrow, SourceCode) select ErrorMessage4, ErrorSeverity, ErrorState, ErrorNumber , ProcedureName, ProcedureLine, MessageDate , GenProcID, RepeatCounter, IsReThrow, SourceCode from dbo.QBM_FTSessionErrorLoad5() l  order by l.RecordNumber end else begin insert into @BufferIntern(ErrorMessage, ErrorSeverity, ErrorState, ErrorNumber , ProcedureName, ProcedureLine6, MessageDate , GenProcID, RepeatCounter, IsReThrow, SourceCode) select ErrorMessage, ErrorSeverity, ErrorState, ErrorNumber , ProcedureName, ProcedureLine7, MessageDate , GenProcID, RepeatCounter, IsReThrow, SourceCode from @ErrorBuffer end select @LastElement = MAX(b.ElementIndex) from @BufferIntern b where8 b.IsReThrow = 0 if exists (select top 1 1 from @BufferIntern b where b.ElementIndex = @LastElement and (b.ErrorNumber in (2812  , 4121  , 21343  ) or 9b.ErrorMessage like '%Could not find stored procedure%' or b.ErrorMessage like '%Cannot find either%or the user-defined function or aggregate%or the name is ambiguous%'10 ) ) begin select @erg = 1 end endLabel: return(@erg) end 11