How to pause execution for particular time or interval ? TIP #71
How to pause execution for particular time or interval ? TIP #71
Suppose, We are working on a stored procedure in which some complex operation is going. We are fetching some value from a table and running some custom operations and after ending of this complex operation, we want a pause of suppose 10 seconds to run another job then in such situation we will use
“WAITFOR DELAY HH:MM: SS”
For example if we want to run select command (second statement)…
View On WordPress


















