Back to OIM Explorer

dbo.QBM_PTransportHistoryInsert

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.320 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_FCVElementToObjectKey1 source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL69 lines
1CREATE PROCEDURE QBM_PTransportHistoryInsert(2  @Module varchar(3),3  @XUser nvarchar(64) = NULL4)5AS6BEGIN7  SET XACT_ABORT OFF8  BEGIN TRY9    DECLARE @Xdate datetime = getutcdate()10    IF @XUser IS NULL11    BEGIN12      SELECT @XUser = OBJECT_NAME(@@procid)13    END14    INSERT INTO QBMTransportHistory(UID_QBMTransportHistory,15    XDateInserted,16    HistoryType,17    Description,18    MigrationVersion,19    Module,20    ItemsSelectedByUser,21    XUserInserted,22    XUserUpdated,23    XDateUpdated,24    TransportFileDate,25    TransportFileName,26    SourceDatabase,27    XTouched,28    XObjectKey)29    SELECT30      w.UID_QBMTransportHistory,31      @Xdate,32      'Migration' AS HistoryType,33      Description,34      MigrationVersion,35      Module,36      0 AS ItemsSelectedByUser,37      @XUser,38      @XUser,39      @Xdate,40      NULL AS TransportFileDate,41      NULL AS TransportFileName,42      NULL AS SourceDatabase,43      '',44      dbo.QBM_FCVElementToObjectKey1('QBMTransportHistory',45      'UID_QBMTransportHistory',46      UID_QBMTransportHistory)47    FROM(48    SELECT49      NEWID() AS UID_QBMTransportHistory,50      x.DisplayValue AS Description,51      x.MigrationVersion AS MigrationVersion,52      x.ModuleName AS Module53    FROM(54    SELECT *55    FROM QBMModuleDef m56    WHERE57      m.ModuleName = @Module) AS x) AS w58  END TRY59  BEGIN CATCH60    EXEC QBM_PSessionErrorAdd DEFAULT61    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()62    RAISERROR(@Rethrow,63    18,64    1)65      WITH NOWAIT66  END CATCH67  endLabel:68  RETURN69END
Open raw exported source
SQL ยท Raw10 lines
1    create   procedure QBM_PTransportHistoryInsert ( @Module varchar(3) , @XUser nvarchar(64) = null ) as begin SET XACT_ABORT OFF BEGIN TRY declare2 @Xdate datetime = getutcdate() if @XUser is null begin select @XUser = OBJECT_NAME(@@procid) end insert into QBMTransportHistory ( UID_QBMTransportHistory3 , XDateInserted , HistoryType , Description , MigrationVersion , Module , ItemsSelectedByUser , XUserInserted , XUserUpdated , XDateUpdated , TransportFileDate4, TransportFileName , SourceDatabase , XTouched , XObjectKey ) select w.UID_QBMTransportHistory , @Xdate , 'Migration' as HistoryType, Description , MigrationVersion5 , Module , 0 as ItemsSelectedByUser , @XUser , @XUser , @Xdate, null as TransportFileDate , null as TransportFileName , null as SourceDatabase , '' , 6dbo.QBM_FCVElementToObjectKey1('QBMTransportHistory', 'UID_QBMTransportHistory', UID_QBMTransportHistory) from ( select NEWID() as UID_QBMTransportHistory7 , x.DisplayValue as Description , x.MigrationVersion as MigrationVersion , x.ModuleName as Module from ( select * from QBMModuleDef m where m.ModuleName8 = @Module ) as x ) as w END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR9 (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return end 10