RamsLessonsLearnt

Saturday, July 11, 2009

SQL to create timeout

"Declare @updateCnt int

set @updateCnt = 0

While(@updateCnt <> 99900000)

begin

set @updateCnt = @updateCnt + 1

end"

Posted by Ramachandran at 12:51 AM
Labels: SQL Server

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Ramachandran
A Software Professional who loves to write
View my complete profile

Blog Archive

  • ►  2021 (4)
    • ►  December (1)
    • ►  October (2)
    • ►  August (1)
  • ►  2016 (2)
    • ►  July (1)
    • ►  June (1)
  • ►  2013 (4)
    • ►  April (4)
  • ►  2012 (1)
    • ►  December (1)
  • ►  2011 (3)
    • ►  July (1)
    • ►  February (2)
  • ►  2010 (8)
    • ►  November (1)
    • ►  September (1)
    • ►  June (1)
    • ►  April (4)
    • ►  February (1)
  • ▼  2009 (13)
    • ►  September (5)
    • ▼  July (4)
      • Ambiguity in Javascript Date comparison
      • SQL to create timeout
      • IIS crash how to analyze
      • On Export & Import to SQL Server
    • ►  April (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2008 (24)
    • ►  December (7)
    • ►  October (3)
    • ►  July (3)
    • ►  June (1)
    • ►  May (1)
    • ►  April (3)
    • ►  February (3)
    • ►  January (3)
  • ►  2007 (31)
    • ►  December (4)
    • ►  November (12)
    • ►  October (1)
    • ►  September (8)
    • ►  July (6)
Simple theme. Powered by Blogger.