WAITFOR DELAY in SQL Server

If you want to pause the execution of the code block for a specific amount of time , you can try using the WAITFOR DELAY statement in SQL Server.

For example , you want to delay the execution say for example 5 seconds and then execute the query.

use AdventureWorks2014
GO
WAITFOR DELAY '0:0:5'
select * from HumanResources.Department
go