Back to OIM Explorer

dbo.QBM_FCVGuidToReplace138

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.498 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_FCVObjectkeyToElement source text reference

References

Referenced By

Complete Source

SQL70 lines
1CREATE FUNCTION dbo.QBM_FCVGuidToReplace138(2  @Value varchar(138),3  @UID_Database varchar(38)4) RETURNS varchar(1385)6AS7BEGIN8  DECLARE @Erg varchar(138)9  DECLARE @CountNodes int10  DECLARE @TableName varchar(30)11  DECLARE @ColumnValue1Old varchar(38)12  DECLARE @ColumnValue1New varchar(38)13  DECLARE @ColumnValue2Old varchar(38)14  DECLARE @ColumnValue2New varchar(38)15  SELECT @Erg = @value16  SELECT17    @CountNodes = dbo.QBM_FCVObjectkeyToElement('CountNodes',18    @value)19  IF @CountNodes IN(1,20  2)21  BEGIN22    SELECT23      @TableName = dbo.QBM_FCVObjectkeyToElement('TableName',24      @value)25    SELECT26      @ColumnValue1Old = dbo.QBM_FCVObjectkeyToElement('ColumnValue1',27      @value)28    IF @CountNodes = 229    BEGIN30      SELECT31        @ColumnValue2Old = dbo.QBM_FCVObjectkeyToElement('ColumnValue2',32        @value)33    END34    SELECT @ColumnValue1new = NULL35    SELECT TOP 1 @ColumnValue1new = r.GuidNew36    FROM QBMGuidReplace r37    WHERE38      r.GuidOld = @ColumnValue1Old AND r.UID_Database = @UID_Database39    IF @ColumnValue1new IS NULL40    BEGIN41      SELECT @ColumnValue1new = @ColumnValue1Old42    END43    IF @CountNodes = 244    BEGIN45      SELECT @ColumnValue2New = NULL46      SELECT TOP 1 @ColumnValue2New = r.GuidNew47      FROM QBMGuidReplace r48      WHERE49        r.GuidOld = @ColumnValue2Old AND r.UID_Database = @UID_Database50      IF @ColumnValue2New IS NULL51      BEGIN52        SELECT @ColumnValue2New = @ColumnValue2Old53      END54    END55    SELECT56      @Erg = CONCAT('<Key><T>',57      @TableName,58      '</T><P>',59      @ColumnValue1new,60      '</P>',61    CASE @CountNodes62      WHEN 2 THEN63    CONCAT('<P>', @ColumnValue2New, '</P>')64    ELSE ''65    END,66    '</Key>')67  END68  endLabel:69  RETURN(@erg)70END
Open raw exported source
SQL ยท Raw11 lines
1  create   function dbo.QBM_FCVGuidToReplace138(@Value varchar(138) ,@UID_Database varchar(38) ) returns varchar(138) as begin declare @Erg varchar2(138) declare @CountNodes int declare @TableName varchar(30) declare @ColumnValue1Old varchar(38) declare @ColumnValue1New varchar(38) declare @ColumnValue2Old3 varchar(38) declare @ColumnValue2New varchar(38) select @Erg = @value select @CountNodes = dbo.QBM_FCVObjectkeyToElement('CountNodes', @value) if @CountNodes4 in (1,2) begin select @TableName = dbo.QBM_FCVObjectkeyToElement('TableName', @value)  select @ColumnValue1Old = dbo.QBM_FCVObjectkeyToElement('ColumnValue1'5, @value) if @CountNodes = 2 begin select @ColumnValue2Old = dbo.QBM_FCVObjectkeyToElement('ColumnValue2', @value) end select @ColumnValue1new = null select6 top 1 @ColumnValue1new = r.GuidNew from QBMGuidReplace r where r.GuidOld = @ColumnValue1Old and r.UID_Database = @UID_Database if @ColumnValue1new is 7null begin select @ColumnValue1new = @ColumnValue1Old end if @CountNodes = 2 begin select @ColumnValue2New = null select top 1 @ColumnValue2New = r.GuidNew8 from QBMGuidReplace r where r.GuidOld = @ColumnValue2Old and r.UID_Database = @UID_Database if @ColumnValue2New is null begin select @ColumnValue2New 9= @ColumnValue2Old end end select @Erg = concat ('<Key><T>' , @TableName , '</T><P>' , @ColumnValue1new , '</P>' , case @CountNodes when 2 then concat(10'<P>' , @ColumnValue2New , '</P>') else '' end , '</Key>' ) end  endLabel: return(@erg) end 11