Back to OIM Explorer

dbo.QBM_FGIDBOwner

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 360 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.

Complete Source

SQL25 lines
1CREATE FUNCTION dbo.QBM_FGIDBOwner(2) RETURNS varchar(33)4AS5BEGIN6  DECLARE @erg varchar(3) = ''7  IF EXISTS(8    SELECT TOP 1 19    FROM sys.tables t10    WHERE11      t.name = 'DialogDatabase')12  BEGIN13    SELECT TOP 1 @erg = d.ModuleOwner14    FROM DialogDatabase d15      WITH(readpast)16    WHERE17      d.IsMainDatabase = 118    IF isnull(@erg,19    '') = ''20    BEGIN21      SELECT @erg = ''22    END23  END24  RETURN(@erg)25END
Open raw exported source
SQL ยท Raw4 lines
1  create   function dbo.QBM_FGIDBOwner() returns varchar(3) as begin declare @erg varchar(3) = '' if exists (select top 1 1 from sys.tables t where2 t.name = 'DialogDatabase' ) begin select top 1 @erg = d.ModuleOwner from DialogDatabase d with (readpast) where d.IsMainDatabase = 1 if isnull(@erg, ''3) = '' begin select @erg = '' end end return(@erg) end 4