Back to OIM Explorer

dbo.QBM_ZSoftwareRevision

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.024 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVBinaryToString source text reference
  • references source dbo.QBM_FCVIntToString source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL46 lines
1CREATE PROCEDURE QBM_ZSoftwareRevision(2  @SlotNumber int,3  @dummy1 varchar(38),4  @dummy2 varchar(38),5  @GenProcIDDummy varchar(38)6)7AS8BEGIN9  DECLARE @erg int10  DECLARE @ChangeContext nvarchar(64) = 'SOFTWAREREVISION'11  DECLARE @XUser nvarchar(64) = object_name(@@procid)12  DECLARE @Xdate datetime = getutcdate()13  BEGIN TRY14    SELECT15      @erg = abs(isnull(CHECKSUM_AGG(x.Summe), 314159))16    FROM(17    SELECT18      CHECKSUM(dbo.QBM_FCVbinaryToString(isnull(r.HashValue, 0x0), 0) + dbo.QBM_FCVIntToString(r.FileSize)) AS Summe19    FROM QBMFileRevision r20    UNION21    SELECT checksum(fht.ObjectKeyDeployTarget + fht.UID_QBMFileRevision)22    FROM QBMFileHasDeployTarget fht) AS x23    UPDATE dialogSemaphor24    SET ChangeCounter = @erg,25    XDateUpdated = @Xdate,26    XUserUpdated = @XUser27    WHERE28      ChangeContext = @ChangeContext29    IF @@rowcount = 030    BEGIN31      RAISERROR('Entry in DialogSemaphor for "SOFTWAREREVISION" not found',32      18,33      1)34        WITH nowait35    END36  END TRY37  BEGIN CATCH38    EXEC QBM_PSessionErrorAdd DEFAULT39    RAISERROR('',40    18,41    1)42      WITH NOWAIT43  END CATCH44  ende:45  RETURN46END
Open raw exported source
SQL ยท Raw8 lines
1   create   procedure QBM_ZSoftwareRevision (@SlotNumber int , @dummy1 varchar(38) , @dummy2 varchar(38) , @GenProcIDDummy varchar(38) ) as begin2 declare @erg int declare @ChangeContext nvarchar(64) = 'SOFTWAREREVISION' declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime 3= getutcdate() BEGIN TRY  select @erg = abs(isnull(CHECKSUM_AGG(x.Summe), 314159)) from ( select CHECKSUM(dbo.QBM_FCVbinaryToString(isnull(r.HashValue,4 0x0),0)+ dbo.QBM_FCVIntToString( r.FileSize)) as Summe  from QBMFileRevision r union  select checksum(fht.ObjectKeyDeployTarget + fht.UID_QBMFileRevision5) from QBMFileHasDeployTarget fht ) as x  update dialogSemaphor set ChangeCounter = @erg , XDateUpdated = @Xdate , XUserUpdated = @XUser where ChangeContext6 = @ChangeContext  if @@rowcount = 0  begin raiserror('Entry in DialogSemaphor for "SOFTWAREREVISION" not found', 18, 1) with nowait end END TRY BEGIN 7CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  ende: return end 8