LISTING 2: Batch That Inserts 100,000 Rows into the Customers Table

SET NOCOUNT ON
DECLARE @counter int
DECLARE @companyname char(25)
SET @counter = 1 
    WHILE @counter < 100001
BEGIN
SET @companyname = 'Knosys'
INSERT INTO customers (customerid, companyname, contactname,
 address, country, gender)
     values(@counter, @companyname,
     ‘contact' + cast(@counter as char),
     'address' + cast(@counter as varchar),
     'USA', 'M')
SET @counter = @counter + 1
END
UPDATE customers SET country = 'Canada'
   WHERE customerid % 10 = 1
UPDATE customers SET country = 'Mexico'
   WHERE customerid % 20 = 0
UPDATE customers SET country = 'Germany'
   WHERE customerid % 2000 = 13
UPDATE customers SET gender = 'F'
 WHERE customerid % 2 = 0