Back to OIM Explorer

dbo.QBM_FGIDBQueueSlotResetType

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 294 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_FTDBQueueSlotResetType source text reference

Complete Source

SQL17 lines
1CREATE FUNCTION dbo.QBM_FGIDBQueueSlotResetType(2  @reason varchar(16)3) RETURNS int4AS5BEGIN6  DECLARE @erg int = 07  SELECT TOP 1 @erg = r.ReasonValue8  FROM dbo.QBM_FTDBQueueSlotResetType() r9  WHERE10    r.ReasonCode = @reason11  IF @erg = 012  BEGIN13    SELECT @erg = -20014  END15  endlabel:16  RETURN(@erg)17END
Open raw exported source
SQL ยท Raw3 lines
1    create   function dbo.QBM_FGIDBQueueSlotResetType (@reason varchar(16) ) returns int as begin declare @erg int = 0 select top 1 @erg = r.ReasonValue2 from dbo.QBM_FTDBQueueSlotResetType() r where r.ReasonCode = @reason if @erg = 0 begin select @erg = -200 end endlabel: return(@erg) end 3