dbo.QBM_PWaitForSeconds
Stored ProcedureSQL_STORED_PROCEDURESandbox DB
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_FCVIntToString source text reference
- references source dbo.QBM_FCVStringPadLeft source text reference
- references source dbo.QBM_FGISessionErrorRethrow source text reference
- references source dbo.QBM_PSessionErrorAdd source text reference
References
- dbo.QBM_FCVIntToString
- dbo.QBM_FCVStringPadLeft
- dbo.QBM_FGISessionErrorRethrow
- dbo.QBM_PSessionErrorAdd
Referenced By
- dbo.QBM_PColumnCustomRemove
- dbo.QBM_PDBQCS_CurrentMoveSlot
- dbo.QBM_PDBQCS_CurrentRestore
- dbo.QBM_PDBQCS_SlotRunner
- dbo.QBM_PDBQueueReplGenProcID
- dbo.QBM_PDialogDBQueueDelete
- dbo.QBM_PExecuteSQLWithRetry_LLP
- dbo.QBM_PJobQueueDelete
- dbo.QBM_PJobQueueInit
- dbo.QBM_PMigrationNotReadyForComp
- dbo.QBM_PQBMDBQueueCurrentDelete
- dbo.QBM_PQBMDBQueuePondDelete
- dbo.QBM_PScheduleCheck
- dbo.QBM_PSlotResetOnMissingItem_L
- dbo.QBM_PWorkDBQueueDelete
- dbo.QBM_PWorkHistoryDelete
- dbo.QBM_PWorkJobQueueDelete
- dbo.QER_P98F5E10C6A9349A1EBFB2C2_
- dbo.QER_PPersonDelete_GDPR
- dbo.QER_PSlotResetOnInvalidRoot_L
- dbo.QER_ZITShopHelperFill
Complete Source
1CREATE PROCEDURE QBM_PWaitForSeconds(2 @SecondsToWait float3)4AS5BEGIN6 SET XACT_ABORT OFF7 BEGIN TRY8 DECLARE @SQLcmd nvarchar(1024)9 DECLARE @Timestring varchar(64)10 DECLARE @SecondsToWait_intern float11 DECLARE @hours int12 DECLARE @Minutes int13 DECLARE @Seconds int14 DECLARE @MilliSeconds int15 SELECT @SecondsToWait_intern = CASE16 WHEN @SecondsToWait > 7200.0 THEN17 7200.018 WHEN isnull(@SecondsToWait,19 0.0) < 0.005 THEN20 0.00521 ELSE @SecondsToWait22 END23 SELECT24 @hours = convert(int,25 @SecondsToWait_intern) / 360026 SELECT27 @SecondsToWait_intern -= convert(float,28 @hours) * 3600.029 SELECT30 @Minutes = convert(int,31 @SecondsToWait_intern) / 6032 SELECT33 @SecondsToWait_intern -= convert(float,34 @Minutes * 60)35 SELECT36 @Seconds = convert(int,37 @SecondsToWait_intern)38 SELECT39 @SecondsToWait_intern -= convert(float,40 @Seconds)41 SELECT42 @MilliSeconds = round(@SecondsToWait_intern*1000.0,43 0)44 SELECT45 @Timestring = dbo.QBM_FCVStringPadLeft(dbo.QBM_FCVIntToString(@hours),46 2,47 '0') + ':' + dbo.QBM_FCVStringPadLeft(dbo.QBM_FCVIntToString(@Minutes),48 2,49 '0') + ':' + dbo.QBM_FCVStringPadLeft(dbo.QBM_FCVIntToString(@Seconds),50 2,51 '0') + '.' + dbo.QBM_FCVStringPadLeft(dbo.QBM_FCVIntToString(@MilliSeconds),52 3,53 '0') waitfor delay @timestring54 END TRY55 BEGIN CATCH56 EXEC QBM_PSessionErrorAdd DEFAULT57 DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()58 RAISERROR(@Rethrow,59 18,60 1)61 WITH NOWAIT62 END CATCH63ENDOpen raw exported source
1 create procedure QBM_PWaitForSeconds (@SecondsToWait float ) as begin SET XACT_ABORT OFF BEGIN TRY declare @SQLcmd nvarchar(1024) declare 2@Timestring varchar(64) declare @SecondsToWait_intern float declare @hours int declare @Minutes int declare @Seconds int declare @MilliSeconds int 3select @SecondsToWait_intern = case when @SecondsToWait > 7200.0 then 7200.0 when isnull(@SecondsToWait, 0.0) < 0.005 then 0.005 else @SecondsToWait end4 select @hours = convert(int, @SecondsToWait_intern) / 3600 select @SecondsToWait_intern -= convert(float, @hours) * 3600.0 select @Minutes = convert(int5, @SecondsToWait_intern ) / 60 select @SecondsToWait_intern -= convert(float, @Minutes * 60) select @Seconds = convert(int, @SecondsToWait_intern ) select6 @SecondsToWait_intern -= convert(float, @Seconds) select @MilliSeconds = round(@SecondsToWait_intern*1000.0, 0) select @Timestring = dbo.QBM_FCVStringPadLeft7( dbo.QBM_FCVIntToString(@hours), 2, '0') + ':' + dbo.QBM_FCVStringPadLeft( dbo.QBM_FCVIntToString(@Minutes), 2, '0') + ':' + dbo.QBM_FCVStringPadLeft(8 dbo.QBM_FCVIntToString(@Seconds), 2, '0') + '.' + dbo.QBM_FCVStringPadLeft( dbo.QBM_FCVIntToString(@MilliSeconds), 3, '0') waitfor delay @timestring 9END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH10 NOWAIT END CATCH end 11