Back to OIM Explorer

dbo.QBM_P1B7262FC192C886D0EB9F74_

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 415 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_PDBQueueInsert_Int source text reference

References

Referenced By

Complete Source

SQL22 lines
1CREATE PROCEDURE QBM_P1B7262FC192C886D0EB9F74_(2  @UID_Task varchar(38)3)4AS5BEGIN6  DECLARE @DBQueueElements_spezial QBM_YDBQueueRaw7  INSERT INTO @DBQueueElements_spezial(Object,8  SubObject,9  GenProcID)10  SELECT11    t.Object,12    t.SubObject,13    t.GenProcID14  FROM #QBMDBQueueTemp t15  WHERE16    t.UID_Task = @UID_Task17  GROUP BY t.Object,18  t.SubObject,19  t.GenProcID20  EXEC QBM_PDBQueueInsert_Int @UID_Task,21    @DBQueueElements_spezial22END
Open raw exported source
SQL ยท Raw4 lines
1  create   procedure QBM_P1B7262FC192C886D0EB9F74_( @UID_Task varchar(38) ) as begin declare @DBQueueElements_spezial QBM_YDBQueueRaw insert into2 @DBQueueElements_spezial (Object, SubObject, GenProcID) select t.Object, t.SubObject, t.GenProcID from #QBMDBQueueTemp t where t.UID_Task = @UID_Task 3 group by t.Object, t.SubObject, t.GenProcID exec QBM_PDBQueueInsert_Int @UID_Task, @DBQueueElements_spezial end 4