Listing 3: Code to Run in Connection 2
SET NOCOUNT ON;
USE testdb;
GO

WHILE 1 = 1
BEGIN
  SELECT * INTO #Employees FROM dbo.Employees;

  IF @@rowcount = 5 BREAK; -- specify 3 to test skipping a row

  DROP TABLE #Employees;
END

SELECT * FROM #Employees;

DROP TABLE #Employees;
GO