Back to OIM Explorer

dbo.QER_PBasetreeOwnsObjectPost

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 508 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.QER_PBasetreeOwnsObjectPost_L source text reference

References

Referenced By

Complete Source

SQL25 lines
1CREATE PROCEDURE QER_PBasetreeOwnsObjectPost(2  @CountDeltaOrigin int,3  @CountDeltaQantity int,4  @SlotNumber int5)6AS7BEGIN8  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent9  INSERT INTO @DBQueueCurrent(GenProcID,10  UID_DialogDBQueue,11  UID_Parameter,12  UID_SubParameter)13  SELECT14    GenProcID,15    UID_DialogDBQueue,16    UID_Parameter,17    UID_SubParameter18  FROM QBMDBQueueCurrent cu19    WITH(readpast)20  WHERE21    cu.SlotNumber = @SlotNumber22  EXEC QER_PBasetreeOwnsObjectPost_L @CountDeltaOrigin,23    @CountDeltaQantity,24    @DBQueueCurrent25END
Open raw exported source
SQL ยท Raw5 lines
1 create   procedure QER_PBasetreeOwnsObjectPost ( @CountDeltaOrigin int , @CountDeltaQantity int , @SlotNumber int ) as begin declare @DBQueueCurrent2 QBM_YDBQueueCurrent insert into @DBQueueCurrent(GenProcID, UID_DialogDBQueue, UID_Parameter, UID_SubParameter) select GenProcID, UID_DialogDBQueue, UID_Parameter3, UID_SubParameter from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber exec QER_PBasetreeOwnsObjectPost_L @CountDeltaOrigin, @CountDeltaQantity4, @DBQueueCurrent end 5