Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...

- Description: A forward-only cursor is the default cursor type in SQL Server. - Behavior: Can only be fetched sequentially from first to last row. Provides high performance (often referred to as a ...