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 ...

In SQL Server, a cursor is a database object that allows you to process the rows of a result set one at a time. This is in contrast to standard T-SQL operations, which typically work on entire sets of ...

An explanation from basic syntax to practical pitfallsYou can use SQL to search for data and retrieve records by specifying ...

Terminates the execution of an iteration of a looping statement and continues with the next iteration if the looping condition is met. This statement may only be used within a compound statement.