This article describes various methods that you can use to iterate through a result set by using Transact-SQL in SQL Server.