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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement