Time Delay to Execute a T-SQL Query

A New feature in SQL Server is Time delay to execute a T-SQL Query
SQL Server will wait for perticular time to excute the query.

Ex :
i) SELECT GETDATE() CurrentTime
WAITFOR DELAY '00:00:20' ---- 5 Second Delay
SELECT GETDATE() CurrentTime

Ex:
ii)
DECLARE @delaytime DATETIME
SET @delaytime = DATEADD(s,20,GETDATE())
SELECT GETDATE() CurrentTime
WAITFOR TIME @delaytime
SELECT GETDATE() CurrentTime

--

Comments

[octav1]

Nice post , thanks for sharing this beautiful information

[octav]

nice blog

[tenant screening services]

 You surely helped me with my research. I will be strolling around and I will see if I can find other valuable resources. But you can be sure that I will recommend this site to my
classmates. More power and I hope to see more developments coming. 

[business process outsourcing]

Very nice share. Thanks for posting.

[school grants for women]

Great Blog I am Certified to your blog Because I have Searched and visited blog contents are Unique. if your blog were not post unique so I would not post my comment.