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


Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.