Back to OIM Explorer

dbo.QBM_FGITriggersDisabled

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL20 lines
1CREATE FUNCTION dbo.QBM_FGITriggersDisabled(2) RETURNS BIT3AS4BEGIN5  DECLARE @erg BIT = 06  IF EXISTS(7    SELECT TOP 1 18    FROM sys.objects o9    WITH(nolock)10  JOIN sys.triggers t11    WITH(nolock)12    ON o.object_id = t.parent_id13  WHERE14    o.type IN('U') AND t.is_disabled = 1)15  BEGIN16    SELECT @erg = 117  END18  endLabel:19  RETURN(@erg)20END
Open raw exported source
SQL ยท Raw4 lines
1   create   function dbo.QBM_FGITriggersDisabled() returns bit  as begin declare @erg bit = 0 if exists (select top 1 1 from sys.objects o with 2(nolock)join sys.triggers t with (nolock) on o.object_id = t.parent_id where o.type in( 'U' ) and t.is_disabled = 1  ) begin select @erg = 1 end  endLabel:3 return (@erg) end 4