Time Delay to Execute a T-SQL Query

Wednesday 17 march 2010 3 17 /03 /Mar /2010 12:44

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

--

More
- Email
- Link
- Print

By Balavardhan Reddy - Posted in: SQL Server2005 - Community: Share Worldwide
Write comment - See the 12 comments

Previous : Export Gridview data to Excel Home Next : SQL Server Rank functions, RANK,...

Comments

Great blog! The information you provide is quiet helpful, why I was not able to find it earlier. Anyways I’ve subscribed to your feeds, keep the good work up.

Comment number1 posted by dissertation blogono blog on 25/03/2010 at 07h24

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.

Comment number2 posted by dissertation graphic blog on 01/04/2010 at 08h03

Great postings i like the above article.

DISSERTATION HELP

Comment number3 posted by DISSERTATION on 29/05/2010 at 08h12

It may be accept by individuals so simply. I feel lots of individuals will agree with you. You will be appropriate that we could to not rely on other people. Who we could to count on is ourself.

Comment number4 posted by Nike Shox Shoes on 18/08/2010 at 05h57

<h1><strong><a href="http://www.wholesalebrandhandbags.com/handbags-gucci-handbags-c-1_15.html">Wholesale Gucci Handbags</a></strong><h1>
<h1><strong><a href="http://www.wholesalebrandhandbags.com/handbags-chanel-handbags-c-1_5.html">Wholesale Chanel Handbags</a></strong><h1>
<h1><strong><a href="http://www.wholesalebrandhandbags.com/handbags-dg-handbags-c-1_11.html">Wholesale D&G Handbags</a></strong><h1>
<h1><strong><a href="http://www.wholesalebrandhandbags.com/wallets-coach-wallets-c-3_10.html">Wholesale Coach Wallets</a></strong><h1>
<h1><strong><a href="http://www.wholesalebrandhandbags.com/wallets-lv-wallets-c-3_20.html">Wholesale LV Wallets</a></strong><h1>
<h1><strong><a href="http://www.wholesalebrandhandbags.com/wallets-gucci-wallets-c-3_16.html">Wholesale Gucci Wallets</a></strong><h1>
<h1><strong><a href="http://www.wholesalebrandhandbags.com/wallets-chanel-wallets-c-3_6.html">Wholesale Chanel Wallets</a></strong><h1>
<h1><strong><a href="http://www.wholesalebrandhandbags.com/sunglasses-lv-sunglasses-c-24_29.html">Wholesale LV Sunglasses</a></strong><h1>
<h1><strong><a href="http://www.wholesalebrandhandbags.com/sunglasses-gucci-sunglasses-c-24_28.html">Wholesale Gucci Sunglasses</a></strong><h1>
<h1><strong><a href="http://www.wholesalebrandhandbags.com/sunglasses-chanel-sunglasses-c-24_25.html">Wholesale Chanel Sunglasses</a></strong><h1>
<h1><strong><a href="http://www.wholesalebrandhandbags.com/sunglasses-dg-sunglasses-c-24_26.html">Wholesale D&G Sunglasses</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/">Wholesale nfl jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/">wholesale jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/">wholesale football jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/">authentic jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/nfl-jerseys-c-206">Wholesale nfl jersey</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/nhl-jerseys-c-249">wholesale nhl jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/nhl-jerseys-c-249">wholesale hockey jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/nhl-jerseys-c-249">discount nhl jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/nba-jerseys-c-168">Wholesale nba jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/nba-jerseys-c-168">wholesale basketball jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/nba-jerseys-c-168">discount nba jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/mlb-jerseys-c-134">Wholesale mlb jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/mlb-jerseys-c-134">wholesale baseball jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/mlb-jerseys-c-134">discount mlb jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/ncaa-jerseys">Wholesale NCAA Jerseys</a></strong><h1>
<h1><strong><a href="http://www.wholesalesportjersey.com/custom-jersey">Wholesale Custom Jersey</a></strong><h1>
<h1><strong><a href="http://www.officialairmaxshop.com/">Nike Air Max</a></strong><H1>
<h1><strong><a href="http://www.officialairmaxshop.com/">Air Max</a></strong><H1>
<h1><strong><a href="http://www.officialairmaxshop.com/">Nike Air Max Shoes</a></strong><H1>
<h1><strong><a href="http://www.officialairmaxshop.com/">Air Max Shoes</a></strong><H1>
<h1><strong><a href="http://www.officialairmaxshop.com/nike-air-max-2010-c-101.html">Nike Air Max 2010</a></strong><H1>
<h1><strong><a href="http://www.officialairmaxshop.com/nike-air-max-95-c-124.html">Air Max 95</a></strong><H1>
<h1><strong><a href="http://www.officialairmaxshop.com/nike-air-max-90-c-144.html">Air Max 90</a></strong><H1>
<h1><strong><a href="http://www.officialairmaxshop.com/nike-air-max-ltd-c-140.html">Air Max LTD</a></strong><H1>
<h1><strong><a href="http://www.officialairmaxshop.com/nike-air-max-tn-c-152.html">Air Max TN</a></strong><H1>
<h1><strong><a href="http://www.officialairmaxshop.com/nike-air-max-skyline-c-159.html">Air Max Skyline</a></strong><H1>
<h1><strong><a href="http://www.officialairmaxshop.com/nike-air-max-classic-bw-c-155.html">Air Max Classic</a></strong><H1>

Comment number5 posted by fiona on 14/04/2011 at 09h53

Comment number6 posted by bulk mail on 03/12/2011 at 03h08

Well explained, thanks.

Comment number7 posted by Muay Thai on 14/01/2012 at 18h49

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.

Comment number8 posted by school grants for women on 31/01/2012 at 11h56

Very nice share. Thanks for posting.

Comment number9 posted by business process outsourcing on 02/02/2012 at 00h16

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.

Comment number10 posted by tenant screening services on 12/03/2012 at 12h55

nice blog

Comment number11 posted by octav on 21/09/2012 at 11h13

Nice post , thanks for sharing this beautiful information

Comment number12 posted by octav1 on 01/10/2012 at 12h38