navigation
 Wednesday, May 07, 2008
T-SQL: An alternative to loops

Here is an interesting article on a way to turn many looping row-based operations into set-based ones: http://www.sqlservercentral.com/articles/TSQL/62867/

I think the idea is a clever one, and I love the "Row By Agonizing Row" (RBAR) acronym!

posted on May 7, 2008  #    by Adam Anderson  Comments [0]
Related posts:
How To Write Secure Dynamic SQL
Good article about some lesser-known differences between temp tables and table variables
Dealing with #1.INF (Positive Infinity) in SQL Server
MSSQL System Stored Procedures Everyone Should Know
Hypothetical Indices
SQL Schema Comparison Tools

Copyright © 2003-2008 Falafel Software Inc.