SQL Server provides several cursor functions that allow you to work with cursors effectively. Cursors are useful when you need to perform row-by-row processing in SQL Server, although they should be ...

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.