Back to OIM Explorer

dbo.QBM_FGIModuleExists

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL20 lines
1CREATE FUNCTION dbo.QBM_FGIModuleExists(2  @ModuleName varchar(3)3) RETURNS BIT4AS5BEGIN6  RETURN(CASE7  WHEN @Modulename = 'CCC' THEN8  19  WHEN isnull(@ModuleName, '') = '' THEN10  011  WHEN EXISTS(12  SELECT TOP 1 113  FROM QBMModuleDef d14    WITH(readpast)15  WHERE16    d.ModuleName = @ModuleName) THEN17  118  ELSE 019  END)20END
Open raw exported source
SQL ยท Raw4 lines
1          create   function dbo.QBM_FGIModuleExists ( @ModuleName varchar(3) ) returns bit  as begin return ( case when @Modulename = 'CCC' then2 1 when isnull(@ModuleName, '') = '' then 0 when exists ( select top 1 1 from QBMModuleDef d with (readpast) where d.ModuleName = @ModuleName ) then 1 3else 0 end ) end 4