Back to OIM Explorer

dbo.QER_FGIAdminUnitForPerson_help

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 372 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_FCVElementToObjectKey1 source text reference
  • references source dbo.QER_FGIAdminUnitForPerson source text reference

Complete Source

SQL17 lines
1CREATE FUNCTION dbo.QER_FGIAdminUnitForPerson_help(2  @uid_dialogcountry varchar(38),3  @uid_dialogState varchar(38)4) RETURNS varchar(1385)6AS7BEGIN8  RETURN(dbo.QBM_FCVElementToObjectKey1(CASE9  WHEN @uid_dialogState > ' ' THEN10  'DialogState'11  ELSE 'DialogCountry'12  END, '', CASE13  WHEN @uid_dialogState > ' ' THEN14  @uid_dialogState15  ELSE @uid_dialogCountry16  END))17END
Open raw exported source
SQL ยท Raw4 lines
1   create   function dbo.QER_FGIAdminUnitForPerson_help (@uid_dialogcountry varchar(38) , @uid_dialogState varchar(38) ) returns varchar(138) as2 begin return( dbo.QBM_FCVElementToObjectKey1( case when @uid_dialogState > ' ' then 'DialogState' else 'DialogCountry' end , '' , case when @uid_dialogState3 > ' ' then @uid_dialogState else @uid_dialogCountry end ) ) end 4