Sample Data for Join Queries

[This document supports a preliminary release of a software product that may be changed substantially prior to final commercial release. This document is provided for informational purposes only.]

This topic provides sample data for the Join Queries and instructions to upload them using SSDS SDK.

1. Save following sample data in (SampleData.txt)

   <Customer xmlns:s="https://schemas.microsoft.com/sitka/2008/03/"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"         
             xmlns:x="http://www.w3.org/2001/XMLSchema">
       <s:Id>c1</s:Id>
       <s:Version>48211</s:Version>
       <Name xsi:type="x:string">Customer 1</Name>
       <AddressLine1 xsi:type="x:string">111 Maple</AddressLine1>
       <City xsi:type="x:string">Seattle</City>
     </Customer>
     <Customer xmlns:s="https://schemas.microsoft.com/sitka/2008/03/" 
               xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
               xmlns:x="http://www.w3.org/2001/XMLSchema">
       <s:Id>c2</s:Id>
       <s:Version>48212</s:Version>
       <Name xsi:type="x:string">Customer 2</Name>
       <AddressLine1 xsi:type="x:string">222 Maple</AddressLine1>
       <City xsi:type="x:string">Bellevue</City>
     </Customer>
     <Employee xmlns:s="https://schemas.microsoft.com/sitka/2008/03/" 
               xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
               xmlns:x="http://www.w3.org/2001/XMLSchema">
       <s:Id>e1</s:Id>
       <s:Version>48213</s:Version>
       <Name xsi:type="x:string">Employee 1</Name>
     </Employee>
     <Order xmlns:s="https://schemas.microsoft.com/sitka/2008/03/"  
            xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"      
            xmlns:x="http://www.w3.org/2001/XMLSchema">
       <s:Id>o1</s:Id>
       <s:Version>48214</s:Version>
       <OrderDate xsi:type="x:dateTime">2008-09-27T23:12:42.1607448</OrderDate>
       <EmployeeID xsi:type="x:string">e1</EmployeeID>
       <CustomerId xsi:type="x:string">c1</CustomerId>
     </Order>
     <Order xmlns:s="https://schemas.microsoft.com/sitka/2008/03/" 
            xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
            xmlns:x="http://www.w3.org/2001/XMLSchema">
       <s:Id>o2</s:Id>
       <s:Version>48215</s:Version>
       <OrderDate xsi:type="x:dateTime">2008-09-27T23:14:48.6311136</OrderDate>
       <EmployeeId xsi:type="x:string">e1</EmployeeId>
       <CustomerId xsi:type="x:string">c1</CustomerId>
     </Order>
     <Order xmlns:s="https://schemas.microsoft.com/sitka/2008/03/" 
            xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
            xmlns:x="http://www.w3.org/2001/XMLSchema">
       <s:Id>o3</s:Id>
       <s:Version>48422</s:Version>
       <OrderDate xsi:type="x:dateTime">2007-09-27T23:14:48.6311136</OrderDate>
       <EmployeeId xsi:type="x:string">e1</EmployeeId>
       <CustomerId xsi:type="x:string">c2</CustomerId>
     </Order>
   

2. Using st.exe command line tool upload the dataSDS Command Line ToolSDS Command Line Tool. At the SSDS Command prompt type the following st loadbatch command.

   SDK Command Prompt>st loadbatch <your-authority-id> <your-container-id> SampleData.txt /host:data.database.windows.net /user:<user-name> /password:<password>
   

To verify data insertion, query the container using the st.exe command line tool or the SSDS Explorer tool.

See Also

Concepts

SDS Command Line Tool
SDS Explorer