Explain WaitFor Delay And WaitFor Time in SQL Server?


Posted on August 6th, 2015 by Hitesh Kumar | 278 Views

WaitFor Delay : It is used for a specified duration relative to the current time.

SELECT GETDATE();
WAITFOR DELAY '00:00:05'; —- Wait 5 seconds
SELECT GETDATE();


WaitFor Time : It is used for actual time of day.

SELECT GETDATE();
WAITFOR TIME '20:00'; -- Wait for 8pm
SELECT GETDATE();

Related posts:

  1. Explain one way, two way, one time and one way to source?
  2. What are @@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT(‘table_name’) in SQl Server?
  3. How to find Tables, Stored Procedure Created in Sql Database
  4. What is Last_Value Function in SQL Server?