jueves, 12 de abril de 2012

GO and WAITFOR

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)

SELECT getdate();
GO 10


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

No hay comentarios:

Publicar un comentario