Back to OIM Explorer

dbo.QBM_FCVF15FFF21396C2F3382AE7_

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 770 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_FCV0C695385CB1124DCEA40A_ source text reference
  • references source dbo.QBM_FCVStringToXMLMasked source text reference

References

Referenced By

Complete Source

SQL23 lines
1CREATE FUNCTION dbo.QBM_FCVF15FFF21396C2F3382AE7_(2  @TableName varchar(32),3  @Value1_int varchar(256),4  @Value2_int varchar(256)5) RETURNS varchar(1386)7AS8BEGIN9  RETURN(CASE10  WHEN len(@Value1_int) = 36 AND len(@Value2_int) = 36 THEN11  CONCAT('<Key><T>', dbo.QBM_FCV0C695385CB1124DCEA40A_(@TableName), '</T><P>', @Value1_int, '</P><P>', @Value2_int,12  '</P></Key>')13  ELSE CONCAT('<Key><T>', dbo.QBM_FCV0C695385CB1124DCEA40A_(@TableName), '</T>', '<P>', CASE14  WHEN @value1_int LIKE '%<%' THEN15  rtrim(dbo.QBM_FCVStringToXMLMasked(@value1_int))16  ELSE rtrim(@value1_int)17  END, '</P>', '<P>', CASE18  WHEN @value2_int LIKE '%<%' THEN19  rtrim(dbo.QBM_FCVStringToXMLMasked(@value2_int))20  ELSE rtrim(@value2_int)21  END, '</P>', '</Key>')22  END)23END
Open raw exported source
SQL ยท Raw7 lines
1  create   function dbo.QBM_FCVF15FFF21396C2F3382AE7_ (@TableName varchar(32), @Value1_int varchar(256), @Value2_int varchar(256) ) returns varchar2(138) as begin return (              case  when len(@Value1_int) = 36 and len(@Value2_int) = 36 then concat('<Key><T>' , dbo.QBM_FCV0C695385CB1124DCEA40A_3(@TableName) , '</T><P>' , @Value1_int , '</P><P>' , @Value2_int , '</P></Key>' ) else   concat('<Key><T>' , dbo.QBM_FCV0C695385CB1124DCEA40A_(@TableName4) , '</T>' , '<P>' , case when @value1_int like '%<%' then rtrim(dbo.QBM_FCVStringToXMLMasked(@value1_int)) else rtrim(@value1_int) end , '</P>' , '<P>'5 , case when @value2_int like '%<%' then rtrim(dbo.QBM_FCVStringToXMLMasked(@value2_int)) else rtrim(@value2_int) end , '</P>' , '</Key>' )  end  ) end6 7