how to use waitfor command in sql

Some times we need to halt a command before executing it.

To achieve this, use the following query

Query

WAITFOR DELAY '000:00:10'
SELECT GETDATE()

this command waits for 10 seconds before executing