Using WAITFOR : WAITFOR « Transact SQL « SQL Server / T-SQL Tutorial






The WAITFOR command delays the execution of Transact-SQL code for a specified length of time.
The syntax for WAITFOR is as follows:
WAITFOR
{
    DELAY 'time_to_pass'
  | TIME 'time_to_execute'
  | ( receive_statement ) [ , TIMEOUT timeout ]
}








20.24.WAITFOR
20.24.1.Using WAITFOR
20.24.2.The WAITFOR Statement
20.24.3.The TIME Parameter
20.24.4.WAITFOR DELAY '00:00:01'