A feature introduced since SQL Server 2005 is the ability to execute the same statement multiple times.
GO X: This example shows for ten times the current date and time (Note that it can differ in miliseconds)
WAITFOR can be used to wait for a specific amount of time or until a specific time has been reached
-- example 1
WAITFOR DELAY ’00:00:15’-- it wait's for 15 seconds
-- example 2
WAITFOR TIME ’09:00:01’ -- it wait's until 09:00:01