Back to OIM Explorer

dbo.QBM_FGIDBQueueActivityDisabled

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL16 lines
1CREATE FUNCTION dbo.QBM_FGIDBQueueActivityDisabled(2) RETURNS BIT3  WITH schemabinding4AS5BEGIN6  RETURN(CASE7  WHEN EXISTS(8  SELECT TOP 1 19  FROM dbo.DialogDatabase d10    WITH(readpast)11  WHERE12    d.IsMainDatabase = 1 AND(d.IsDBSchedulerDisabled = 1 OR d.SingleUserProcess > 0)) THEN13  114  ELSE 015  END)16END
Open raw exported source
SQL ยท Raw3 lines
1  create   function dbo.QBM_FGIDBQueueActivityDisabled() returns bit with schemabinding as begin return( case when exists (select top 1 1 from dbo.DialogDatabase2 d with (readpast) where d.IsMainDatabase = 1 and (d.IsDBSchedulerDisabled = 1 or d.SingleUserProcess > 0 ) ) then 1 else 0 end ) end 3