Overblog Follow this blog
Edit post Administration Create my blog
Balavardhan Reddy Narani

Time Delay to Execute a T-SQL Query

March 17 2010 , Written by Balavardhan Reddy Published on #SQL Server2005




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


--

Share this post

Repost 0

Comment on this post

octav1 10/01/2012 12:38


Nice post , thanks for sharing this beautiful information

octav 09/21/2012 11:13


nice blog

tenant screening services 03/12/2012 12:55


 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 02/02/2012 00:16


Very nice share. Thanks for posting.

school grants for women 01/31/2012 11:56


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.