LISTING 1: Code That Creates Large Copy of Order Details Table

USE Northwind
/* Create a copy of the Order Details table with an identity column that 
will keep all the rows unique. The table is then repeatedly copied into itself. 
By changing the upper limit in the WHILE statement, you can control how 
many rows are in the table.*/
INTO od
FROM [order details]
GO
SET NOCOUNT ON
DECLARE @loop tinyint
SET @loop = 1
WHILE @loop < 9 begin
        INSERT INTO od ([OrderID], [ProductID], [UnitPrice], [Quantity], [Discount])
        SELECT [OrderID], [ProductID], [UnitPrice], [Quantity], [Discount] FROM od 
        SET @loop = @loop + 1
END
GO
SELECT count(*) FROM od
GO