SQL Server Performance Tip : Row-by-Row Operations Without Cursors

    In general, SQL Cursors are very useful and powerful because they offer a high degree of row-level data manipulation, but this power comes at a price: negative performance. So sometimes we need to use non-cursor-based techniques for high-performance. In this article, David VanDeSompele describes a technique for performing row by row operations without using a cursor. 
    Very useful.

转载于:https://www.cnblogs.com/fengzhimei/archive/2004/07/04/21080.html