Mega Code Archive
Using 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 ]
}