LISTING 1: Batches Attempting to Return 
Five Rows from the Orders Table

--Batch 1:
USE Northwind
DECLARE @n int
SET @n = 5
SET ROWCOUNT @n
SELECT * FROM orders
SET ROWCOUNT 0


--Batch 2:
DECLARE @n int
SET @n = 5
SELECT TOP @n * FROM orders