Back to OIM Explorer

dbo.QBM_FGIMultilanguageValue

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.552 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.

References

  • No direct source references extracted.

Referenced By

  • No direct source references extracted.

Complete Source

SQL65 lines
1CREATE FUNCTION dbo.QBM_FGIMultilanguageValue(2  @TableNameTarget nvarchar(64),3  @ColumnNameTarget nvarchar(64),4  @uid_dialogCulture varchar(38),5  @key nvarchar(1024)6) RETURNS nvarchar(max7)8AS9BEGIN10  DECLARE @erg nvarchar(max) = NULL11  DECLARE @uid_dialogColumn varchar(38)12  DECLARE @keyIntern nvarchar(1024)13  SELECT @uid_dialogColumn = NULL14  SELECT TOP 1 @uid_dialogColumn = uid_dialogColumn15  FROM dbo.DialogColumn c16  JOIN dbo.DialogTable t17    ON c.UID_DialogTable = t.UID_DialogTable18  WHERE19    t.TableName = @TableNameTarget AND c.ColumnName = @ColumnNameTarget20  IF @uid_dialogColumn IS NULL21  BEGIN22    RETURN(isnull(@erg, ''))23  END24  SELECT @keyIntern = @key25  IF26  LEFT(@keyIntern,27  5) = '#' + 'L' + 'D' + 'S' + '#'28  BEGIN29    SELECT30      @keyIntern = substring(@keyIntern,31      6,32      1024)33  END34  IF35  RIGHT(@keyIntern,36  1) = '|'37  BEGIN38    SELECT39      @keyIntern = substring(@keyIntern,40      1,41      len(@keyintern) - 1)42  END43  SELECT TOP 1 @erg = m.EntryValue44  FROM dbo.DialogMultiLanguage m45  WHERE46    m.UID_DialogColumn = @uid_dialogColumn AND m.UID_DialogCulture = @uid_dialogCulture AND m.EntryKey = @keyIntern47  IF @erg > ' '48  BEGIN49    RETURN(isnull(@erg, ''))50  END51  SELECT TOP 1 @erg = m.EntryValue52  FROM dbo.DialogMultiLanguage m53  JOIN dbo.DialogColumn c54    ON m.UID_DialogColumn = c.UID_DialogColumn55  JOIN dbo.QBMColumnTranslation ao56    ON ao.ObjectKeyDialogColumnSource = c.XObjectKey57  WHERE58    ao.UID_DialogColumnTarget = @uid_dialogColumn AND m.UID_DialogCulture = @uid_dialogCulture AND m.EntryKey = @keyIntern59  IF @erg IS NULL60  BEGIN61    SELECT @erg = @keyIntern62  END63  endLabel:64  RETURN(isnull(@erg, ''))65END
Open raw exported source
SQL ยท Raw11 lines
1     create   function dbo.QBM_FGIMultilanguageValue (@TableNameTarget nvarchar(64), @ColumnNameTarget nvarchar(64), @uid_dialogCulture varchar(382), @key nvarchar(1024) ) returns nvarchar(max)   as begin declare @erg nvarchar(max) = null declare @uid_dialogColumn varchar(38) declare @keyIntern nvarchar3(1024) select @uid_dialogColumn = null select top 1 @uid_dialogColumn = uid_dialogColumn from dbo.DialogColumn c join dbo.DialogTable t on c.UID_DialogTable4 = t.UID_DialogTable where t.TableName = @TableNameTarget and c.ColumnName = @ColumnNameTarget  if @uid_dialogColumn is null begin  return (isnull(@erg5, ''))  end select @keyIntern = @key if left(@keyIntern, 5) = '#' + 'L' + 'D' + 'S' + '#' begin select @keyIntern = substring(@keyIntern, 6, 1024) end 6 if right(@keyIntern, 1) = '|' begin select @keyIntern = substring(@keyIntern, 1, len(@keyintern) - 1) end select top 1 @erg = m.EntryValue from dbo.DialogMultiLanguage7 m where m.UID_DialogColumn = @uid_dialogColumn and m.UID_DialogCulture = @uid_dialogCulture and m.EntryKey = @keyIntern if @erg > ' ' begin  return (isnull8(@erg, ''))  end  select top 1 @erg = m.EntryValue from dbo.DialogMultiLanguage m join dbo.DialogColumn c on m.UID_DialogColumn = c.UID_DialogColumn join9 dbo.QBMColumnTranslation ao on ao.ObjectKeyDialogColumnSource = c.XObjectKey where ao.UID_DialogColumnTarget = @uid_dialogColumn and m.UID_DialogCulture10 = @uid_dialogCulture and m.EntryKey = @keyIntern if @erg is null begin select @erg = @keyIntern end endLabel: return (isnull(@erg, '')) end 11