Back to OIM Explorer

dbo.QBM_FGIServerEngineProperties

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL37 lines
1CREATE FUNCTION dbo.QBM_FGIServerEngineProperties(2  @PropertyName varchar(64)3) RETURNS int4AS5BEGIN6  RETURN(7  SELECT TOP 1 CASE @PropertyName8  WHEN 'EngineNumber' THEN9  v.EngineNumber10  WHEN 'UseForOneIM' THEN11  v.UseForOneIM12  WHEN 'UseUse' THEN13  v.UseUse14  WHEN 'MemoryOptimizedAvailable' THEN15  v.MemoryOptimizedAvailable16  WHEN 'HADRpossible' THEN17  v.HADRpossible18  WHEN 'SimpleRecoveryPossible' THEN19  v.SimpleRecoveryPossible20  WHEN 'OnlineIndexing' THEN21  v.OnlineIndexing22  WHEN 'HasExtendedProc' THEN23  v.HasExtendedProc24  WHEN 'IsAmazonRDS' THEN25  v.IsAmazonRDS26  WHEN 'AccessToFileSpaceUsage' THEN27  v.AccessToFileSpaceUsage28  WHEN 'WaitForGhostProcess' THEN29  v.WaitForGhostProcess30  WHEN 'AccessToServerPrincipal' THEN31  v.AccessToServerPrincipal32  WHEN 'PercentQuality' THEN33  v.PercentQuality34  ELSE -135  END36  FROM QBM_VServerEngineProperties v)37END
Open raw exported source
SQL ยท Raw7 lines
1  create   function dbo.QBM_FGIServerEngineProperties (@PropertyName varchar(64) ) returns int as begin return( select top 1 case @PropertyName 2when 'EngineNumber' then v.EngineNumber when 'UseForOneIM' then v.UseForOneIM when 'UseUse' then v.UseUse when 'MemoryOptimizedAvailable' then v.MemoryOptimizedAvailable3  when 'HADRpossible' then v.HADRpossible when 'SimpleRecoveryPossible' then v.SimpleRecoveryPossible when 'OnlineIndexing' then v.OnlineIndexing when 4'HasExtendedProc' then v.HasExtendedProc when 'IsAmazonRDS' then v.IsAmazonRDS when 'AccessToFileSpaceUsage' then v.AccessToFileSpaceUsage when 'WaitForGhostProcess'5 then v.WaitForGhostProcess when 'AccessToServerPrincipal' then v.AccessToServerPrincipal when 'PercentQuality' then v.PercentQuality else -1 end from 6QBM_VServerEngineProperties v ) end 7