Back to OIM Explorer

dbo.QER_FCVDynGuidToProcName

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

Complete Source

SQL18 lines
1CREATE FUNCTION dbo.QER_FCVDynGuidToProcName(2  @UID_DynamicGroup varchar(38),3  @area varchar(16)4) RETURNS varchar(305)6AS7BEGIN8  DECLARE @erg varchar(30)9  SELECT @erg = dbo.QBM_FGICodeName('P' + CASE @area10  WHEN 'All' THEN11  'A'12  WHEN 'Detail' THEN13  'D'14  ELSE '?'15  END,16  @UID_DynamicGroup) endLabel:17  RETURN(@erg)18END
Open raw exported source
SQL ยท Raw4 lines
1   create   function dbo.QER_FCVDynGuidToProcName(@UID_DynamicGroup varchar(38) , @area varchar(16)     ) returns varchar(30) as begin declare @erg2 varchar(30) select @erg = dbo.QBM_FGICodeName( 'P' + case @area when 'All' then 'A' when 'Detail' then 'D' else '?'  end , @UID_DynamicGroup) endLabel:3 return(@erg) end 4