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

1. SQL Server / T-SQL Tutorial
2. Transact SQL
3. WAITFOR

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 ]
}