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



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


--

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

My Blog

Profile

  • Balavardhan Reddy
  • Balavardhan Reddy Narani
  • Male
  • Life ASP.Net SQL Server Good Quotes SSRS
  • Software Eng.. From India..

Categories

Random pictures

  • 4.jpg
  • 3.gif
  • 2.jpg
  • 2.gif
  • 5.jpg

Recent comments

Recommend

Links

Create your blog for free on over-blog.com - Contact - Terms of Service - Earn Royalties - Report abuse - Most commented articles