3 require_once "bootstrap.php";
5 $shardManager->selectShard(0);
7 $conn->insert("Products", array(
10 "ProductName" => 'Titanium Extension Bracket Left Hand',
13 $conn->insert("Products", array(
16 "ProductName" => 'Titanium Extension Bracket Right Hand',
19 $conn->insert("Products", array(
22 "ProductName" => 'Fusion Generator Module 5 kV',
25 $conn->insert("Products", array(
28 "ProductName" => 'Bypass Filter 400 MHz Low Pass',
32 $conn->insert("Customers", array(
34 'CompanyName' => 'Van Nuys',
35 'FirstName' => 'Catherine',
38 $conn->insert("Customers", array(
40 'CompanyName' => 'Abercrombie',
42 'LastName' => 'Branch',
44 $conn->insert("Customers", array(
46 'CompanyName' => 'Contoso',
47 'FirstName' => 'Frances',
48 'LastName' => 'Adams',
50 $conn->insert("Customers", array(
52 'CompanyName' => 'A. Datum Corporation',
53 'FirstName' => 'Mark',
54 'LastName' => 'Harrington',
56 $conn->insert("Customers", array(
58 'CompanyName' => 'Adventure Works',
59 'FirstName' => 'Keith',
60 'LastName' => 'Harris',
62 $conn->insert("Customers", array(
64 'CompanyName' => 'Alpine Ski House',
65 'FirstName' => 'Wilson',
68 $conn->insert("Customers", array(
70 'CompanyName' => 'Baldwin Museum of Science',
71 'FirstName' => 'Roger',
72 'LastName' => 'Harui',
74 $conn->insert("Customers", array(
76 'CompanyName' => 'Blue Yonder Airlines',
77 'FirstName' => 'Pilar',
78 'LastName' => 'Pinilla',
80 $conn->insert("Customers", array(
82 'CompanyName' => 'City Power & Light',
83 'FirstName' => 'Kari',
84 'LastName' => 'Hensien',
86 $conn->insert("Customers", array(
88 'CompanyName' => 'Coho Winery',
89 'FirstName' => 'Peter',
90 'LastName' => 'Brehm',
93 $conn->executeUpdate("
96 DECLARE @customerId INT
99 SELECT @customerId = CustomerId FROM Customers WHERE LastName = 'Hensien' and FirstName = 'Kari'
101 INSERT INTO Orders (CustomerId, OrderId, OrderDate)
102 VALUES (@customerId, @orderId, GetDate())
104 INSERT INTO OrderItems (CustomerID, OrderID, ProductID, Quantity)
105 VALUES (@customerId, @orderId, 388, 4)
108 SELECT @customerId = CustomerId FROM Customers WHERE LastName = 'Harui' and FirstName = 'Roger'
110 INSERT INTO Orders (CustomerId, OrderId, OrderDate)
111 VALUES (@customerId, @orderId, GetDate())
113 INSERT INTO OrderItems (CustomerID, OrderID, ProductID, Quantity)
114 VALUES (@customerId, @orderId, 389, 2)
117 SELECT @customerId = CustomerId FROM Customers WHERE LastName = 'Brehm' and FirstName = 'Peter'
119 INSERT INTO Orders (CustomerId, OrderId, OrderDate)
120 VALUES (@customerId, @orderId, GetDate())
122 INSERT INTO OrderItems (CustomerID, OrderID, ProductID, Quantity)
123 VALUES (@customerId, @orderId, 387, 3)
126 SELECT @customerId = CustomerId FROM Customers WHERE LastName = 'Pais' and FirstName = 'Wilson'
128 INSERT INTO Orders (CustomerId, OrderId, OrderDate)
129 VALUES (@customerId, @orderId, GetDate())
131 INSERT INTO OrderItems (CustomerID, OrderID, ProductID, Quantity)
132 VALUES (@customerId, @orderId, 388, 1)");