#waitfor delay

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)…