The "WAITFOR" KeyWord With in SqlServer

The "WAITFOR" Statement Suspends the Execution of a connection until either
- A specified time interval has passed
- A specified time day is Reached
EX:
use pubs
waitfor delay '00:00:05'
select * from sales

Disadvantages:
The Connection from the application remains suspended until the wait for complete.this is used at Stored Procedure