--- /dev/null
+<?php
+// insert_data.php
+require_once "bootstrap.php";
+
+$shardManager->selectShard(0);
+
+$conn->insert("Products", array(
+ "ProductID" => 386,
+ "SupplierID" => 1001,
+ "ProductName" => 'Titanium Extension Bracket Left Hand',
+ "Price" => 5.25,
+));
+$conn->insert("Products", array(
+ "ProductID" => 387,
+ "SupplierID" => 1001,
+ "ProductName" => 'Titanium Extension Bracket Right Hand',
+ "Price" => 5.25,
+));
+$conn->insert("Products", array(
+ "ProductID" => 388,
+ "SupplierID" => 1001,
+ "ProductName" => 'Fusion Generator Module 5 kV',
+ "Price" => 10.50,
+));
+$conn->insert("Products", array(
+ "ProductID" => 389,
+ "SupplierID" => 1001,
+ "ProductName" => 'Bypass Filter 400 MHz Low Pass',
+ "Price" => 10.50,
+));
+
+$conn->insert("Customers", array(
+ 'CustomerID' => 10,
+ 'CompanyName' => 'Van Nuys',
+ 'FirstName' => 'Catherine',
+ 'LastName' => 'Abel',
+));
+$conn->insert("Customers", array(
+ 'CustomerID' => 20,
+ 'CompanyName' => 'Abercrombie',
+ 'FirstName' => 'Kim',
+ 'LastName' => 'Branch',
+));
+$conn->insert("Customers", array(
+ 'CustomerID' => 30,
+ 'CompanyName' => 'Contoso',
+ 'FirstName' => 'Frances',
+ 'LastName' => 'Adams',
+));
+$conn->insert("Customers", array(
+ 'CustomerID' => 40,
+ 'CompanyName' => 'A. Datum Corporation',
+ 'FirstName' => 'Mark',
+ 'LastName' => 'Harrington',
+));
+$conn->insert("Customers", array(
+ 'CustomerID' => 50,
+ 'CompanyName' => 'Adventure Works',
+ 'FirstName' => 'Keith',
+ 'LastName' => 'Harris',
+));
+$conn->insert("Customers", array(
+ 'CustomerID' => 60,
+ 'CompanyName' => 'Alpine Ski House',
+ 'FirstName' => 'Wilson',
+ 'LastName' => 'Pais',
+));
+$conn->insert("Customers", array(
+ 'CustomerID' => 70,
+ 'CompanyName' => 'Baldwin Museum of Science',
+ 'FirstName' => 'Roger',
+ 'LastName' => 'Harui',
+));
+$conn->insert("Customers", array(
+ 'CustomerID' => 80,
+ 'CompanyName' => 'Blue Yonder Airlines',
+ 'FirstName' => 'Pilar',
+ 'LastName' => 'Pinilla',
+));
+$conn->insert("Customers", array(
+ 'CustomerID' => 90,
+ 'CompanyName' => 'City Power & Light',
+ 'FirstName' => 'Kari',
+ 'LastName' => 'Hensien',
+));
+$conn->insert("Customers", array(
+ 'CustomerID' => 100,
+ 'CompanyName' => 'Coho Winery',
+ 'FirstName' => 'Peter',
+ 'LastName' => 'Brehm',
+));
+
+$conn->executeUpdate("
+ DECLARE @orderId INT
+
+ DECLARE @customerId INT
+
+ SET @orderId = 10
+ SELECT @customerId = CustomerId FROM Customers WHERE LastName = 'Hensien' and FirstName = 'Kari'
+
+ INSERT INTO Orders (CustomerId, OrderId, OrderDate)
+ VALUES (@customerId, @orderId, GetDate())
+
+ INSERT INTO OrderItems (CustomerID, OrderID, ProductID, Quantity)
+ VALUES (@customerId, @orderId, 388, 4)
+
+ SET @orderId = 20
+ SELECT @customerId = CustomerId FROM Customers WHERE LastName = 'Harui' and FirstName = 'Roger'
+
+ INSERT INTO Orders (CustomerId, OrderId, OrderDate)
+ VALUES (@customerId, @orderId, GetDate())
+
+ INSERT INTO OrderItems (CustomerID, OrderID, ProductID, Quantity)
+ VALUES (@customerId, @orderId, 389, 2)
+
+ SET @orderId = 30
+ SELECT @customerId = CustomerId FROM Customers WHERE LastName = 'Brehm' and FirstName = 'Peter'
+
+ INSERT INTO Orders (CustomerId, OrderId, OrderDate)
+ VALUES (@customerId, @orderId, GetDate())
+
+ INSERT INTO OrderItems (CustomerID, OrderID, ProductID, Quantity)
+ VALUES (@customerId, @orderId, 387, 3)
+
+ SET @orderId = 40
+ SELECT @customerId = CustomerId FROM Customers WHERE LastName = 'Pais' and FirstName = 'Wilson'
+
+ INSERT INTO Orders (CustomerId, OrderId, OrderDate)
+ VALUES (@customerId, @orderId, GetDate())
+
+ INSERT INTO OrderItems (CustomerID, OrderID, ProductID, Quantity)
+ VALUES (@customerId, @orderId, 388, 1)");