Back to OIM Explorer

dbo.QBM_FGIDashBoardCodeName

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 294 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FGICodeName source text reference

References

Referenced By

Complete Source

SQL17 lines
1CREATE FUNCTION dbo.QBM_FGIDashBoardCodeName(2  @Area varchar(16),3  @UID_DialogDashBoardDef varchar(38)4) RETURNS varchar(305)6AS7BEGIN8  RETURN(dbo.QBM_FGICodeName(CASE @Area9  WHEN 'View' THEN10  'VA'11  WHEN 'View100' THEN12  'V1'13  WHEN 'proc' THEN14  'P'15  ELSE NULL16  END, @UID_DialogDashBoardDef))17END
Open raw exported source
SQL ยท Raw3 lines
1   create   function dbo.QBM_FGIDashBoardCodeName( @Area varchar(16) , @UID_DialogDashBoardDef varchar(38)  ) returns varchar(30)as begin return2(dbo.QBM_FGICodeName(case @Area when 'View' then 'VA' when 'View100' then 'V1' when 'proc' then 'P' else null end, @UID_DialogDashBoardDef) ) end 3