THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server » Transact SQL » Infinite loops   (RSS)
  • When you process your rows one by one, avoid infinite loops

    When you process your rows one by one in a loop, you need to make sure that your loop never runs infinitely. I will describe three scenarios with possible infinite loops. There have been many articles discussing feasibility of loops vs. set-based solutions – I will not repeat any of these arguments. Let us assume that you need to use some ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on April 23, 2009
  • Avoiding infinite loops. Part One.

    Although there are many discussions about which kind of cursor or loop performs the best, there is no doubt which loops perform the worst – the infinite ones of course. Whenever you write a loop, you need to make sure that it never runs infinitely. I will provide two examples, two rather common scenarios that may potentially cause loops to ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on April 20, 2009
  Privacy Statement