SQL SERVER – Time Delay While Running T-SQL Query

Option 1 : Waitfor Delay in executing T-SQL
T-SQL runs after particular delay is completed.
--------------------------------------------------------------

SELECT GETDATE() CurrentTime
WAITFOR DELAY '00:00:05' ---- 5 Second Delay
SELECT GETDATE() CurrentTime


----------------------------------


Option 2 : Waitfor Time in executing T-SQL
T-SQL runs after particular time has arrived.
--------------------------------------------------------------


DECLARE @MyDateTime DATETIME
/* Add 5 seconds to current time so
system waits for 5 seconds*/
SET @MyDateTime = DATEADD(s,5,GETDATE())
SELECT GETDATE() CurrentTime
WAITFOR TIME @MyDateTime
SELECT GETDATE() CurrentTime