northwind.dsv

来自「< SQL Server2005程序设计>」· DSV 代码 · 共 580 行 · 第 1/3 页

DSV
580 行
字号
123
            <xs:element name="dbo_vwShippers" msprop:FriendlyName="vwShippers" msprop:DbSchemaName="dbo" msprop:DbTableName="vwShippers" msprop:design-time-name="74a3d23f-2192-4623-a48b-20b820f01bca" msprop:TableType="View">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="ShipperId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:FriendlyName="ShipperId" msprop:DbColumnName="ShipperId" msprop:design-time-name="164281f8-bd68-4afc-ba8d-b32cee361128" type="xs:int" />
                  <xs:element name="ShipperName" msprop:FriendlyName="ShipperName" msprop:DbColumnName="ShipperName" msprop:design-time-name="a08ce299-93ae-4927-965e-a34b04c52822">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="40" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_vwProducts" msprop:FriendlyName="vwProducts" msprop:DbSchemaName="dbo" msprop:DbTableName="vwProducts" msprop:design-time-name="11da3704-3faf-4eb8-9fe0-369c688d85ce" msprop:TableType="View">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="ProductID" msprop:FriendlyName="ProductID" msprop:DbColumnName="ProductID" msprop:design-time-name="be380be7-ed4f-4868-8b03-e6db8b18254e" type="xs:int" />
                  <xs:element name="ProductName" msprop:FriendlyName="ProductName" msprop:DbColumnName="ProductName" msprop:design-time-name="dd72d523-9a81-4aa4-ae76-77d787420f11">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="40" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="CategoryName" msprop:FriendlyName="CategoryName" msprop:DbColumnName="CategoryName" msprop:design-time-name="c0c539ac-e62a-4939-bbb5-421baf9719eb">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_vwGeography" msprop:FriendlyName="vwGeography" msprop:DbSchemaName="dbo" msprop:DbTableName="vwGeography" msprop:design-time-name="0a43d825-5914-475c-ab4d-acc44d8a23c4" msprop:TableType="View">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="PostalCode" msprop:FriendlyName="PostalCode" msprop:DbColumnName="PostalCode" msprop:design-time-name="311c3200-c6b4-42f3-9fdc-a93dd75a7282">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="10" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="City" msprop:FriendlyName="City" msprop:DbColumnName="City" msprop:design-time-name="65c8cf15-62e7-4c8a-b82f-4a9ba1041e60" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="State" msprop:FriendlyName="State" msprop:DbColumnName="State" msprop:design-time-name="8e2154c5-cdaf-4c2c-8544-7210cd3dfe9c" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Country" msprop:FriendlyName="Country" msprop:DbColumnName="Country" msprop:design-time-name="d4ebc1f3-dd97-4844-9d50-86824a6bab2e" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_vwEmployees" msprop:FriendlyName="vwEmployees" msprop:DbSchemaName="dbo" msprop:DbTableName="vwEmployees" msprop:design-time-name="23ea16cc-e18c-4495-9a49-b8166bb3e7a5" msprop:TableType="View">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="EmployeeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:FriendlyName="EmployeeID" msprop:DbColumnName="EmployeeID" msprop:design-time-name="243381f0-92f3-48b6-a996-62f014c0cf06" type="xs:int" />
                  <xs:element name="EmployeeName" msdata:ReadOnly="true" msprop:FriendlyName="EmployeeName" msprop:DbColumnName="EmployeeName" msprop:design-time-name="b036a709-0ad5-43b9-84b3-df36fb4886ab">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="32" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_vwSuppliers" msprop:FriendlyName="vwSuppliers" msprop:DbSchemaName="dbo" msprop:DbTableName="vwSuppliers" msprop:design-time-name="fce6797a-bfc4-4b36-895f-138b0c1a2410" msprop:TableType="View">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="ProductID" msprop:FriendlyName="ProductID" msprop:DbColumnName="ProductID" msprop:design-time-name="35afb3e1-b66b-45d0-a03f-8c3a5bed9303" type="xs:int" />
                  <xs:element name="ProductName" msprop:FriendlyName="ProductName" msprop:DbColumnName="ProductName" msprop:design-time-name="b68111a5-0d8a-49e0-9919-5a6a269bfa69">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="40" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="SupplierName" msprop:FriendlyName="SupplierName" msprop:DbColumnName="SupplierName" msprop:design-time-name="0a44cd48-bda1-464e-a0b7-af0417c094f2">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="40" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Employees" msprop:QueryDefinition="SELECT     EmployeeID, LastName + ', ' + FirstName AS EmployeeName, ReportsTo&#xD;&#xA;FROM         Employees" msprop:DbTableName="Employees" msprop:QueryBuilder="SpecificQueryBuilder" msprop:IsLogical="True" msprop:FriendlyName="Employees" msprop:design-time-name="75bdc755-4848-4675-a958-8c9439ea72e8" msprop:TableType="View">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="EmployeeID" msprop:FriendlyName="EmployeeID" msprop:DbColumnName="EmployeeID" msprop:design-time-name="29b808af-9660-498b-a4b3-61e2d1334bdf" type="xs:int" />
                  <xs:element name="EmployeeName" msdata:ReadOnly="true" msprop:FriendlyName="EmployeeName" msprop:DbColumnName="EmployeeName" msprop:design-time-name="5379fe90-c066-41ad-bc71-b8e3bc06af8d" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="32" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="ReportsTo" msprop:FriendlyName="ReportsTo" msprop:DbColumnName="ReportsTo" msprop:design-time-name="cc991784-eb2d-4166-b8e4-6cda1ddc56a2" type="xs:int" minOccurs="0" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_tblMonthNames" msprop:FriendlyName="tblMonthNames" msprop:DbSchemaName="dbo" msprop:DbTableName="tblMonthNames" msprop:design-time-name="40f21234-7a95-4afe-8582-df0157b56a64" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="MonthNumber" msprop:FriendlyName="MonthNumber" msprop:DbColumnName="MonthNumber" msprop:design-time-name="97594545-f8da-4de7-bbf1-7f91a1534b45" type="xs:int" />
                  <xs:element name="EnglishMonthName" msprop:FriendlyName="EnglishMonthName" msprop:DbColumnName="EnglishMonthName" msprop:design-time-name="79bfce8c-b33a-4702-9714-4328469ecbe8" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="SpanishMonthName" msprop:FriendlyName="SpanishMonthName" msprop:DbColumnName="SpanishMonthName" msprop:design-time-name="81664ab7-3cab-44d8-9d40-db1e2eb043b2" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:choice>
        </xs:complexType>
        <xs:unique name="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_tblTime" />
          <xs:field xpath="TimeKey" />
        </xs:unique>
        <xs:unique name="dbo_vwShippers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_vwShippers" />
          <xs:field xpath="ShipperId" />
        </xs:unique>
        <xs:unique name="dbo_vwProducts_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_vwProducts" />
          <xs:field xpath="ProductID" />
        </xs:unique>
        <xs:unique name="dbo_vwGeography_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_vwGeography" />
          <xs:field xpath="PostalCode" />
        </xs:unique>
        <xs:unique name="dbo_vwEmployees_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_vwEmployees" />
          <xs:field xpath="EmployeeID" />
        </xs:unique>
        <xs:unique name="dbo_vwSuppliers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_vwSuppliers" />
          <xs:field xpath="ProductID" />
        </xs:unique>
        <xs:unique name="Employees_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Employees" />
          <xs:field xpath="EmployeeID" />
        </xs:unique>
        <xs:unique name="dbo_tblMonthNames_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_tblMonthNames" />
          <xs:field xpath="MonthNumber" />
        </xs:unique>
      </xs:element>
      <xs:annotation>
        <xs:appinfo>
          <msdata:Relationship name="tblFact-vwProducts" msdata:parent="dbo_vwProducts" msdata:child="dbo_tblFact" msdata:parentkey="ProductID" msdata:childkey="ProductID" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="tblFact-vwGeography" msdata:parent="dbo_vwGeography" msdata:child="dbo_tblFact" msdata:parentkey="PostalCode" msdata:childkey="PostalCode" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="tblFact-vwSuppliers" msdata:parent="dbo_vwSuppliers" msdata:child="dbo_tblFact" msdata:parentkey="ProductID" msdata:childkey="ProductID" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="tblFact-tblTime" msdata:parent="dbo_tblTime" msdata:child="dbo_tblFact" msdata:parentkey="TimeKey" msdata:childkey="TimeKey" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="tblFact-vwShippers" msdata:parent="dbo_vwShippers" msdata:child="dbo_tblFact" msdata:parentkey="ShipperId" msdata:childkey="ShipperId" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="tblFact-vwEmployees" msdata:parent="dbo_vwEmployees" msdata:child="dbo_tblFact" msdata:parentkey="EmployeeID" msdata:childkey="EmployeeId" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="tblFact-Employees" msdata:parent="Employees" msdata:child="dbo_tblFact" msdata:parentkey="EmployeeID" msdata:childkey="EmployeeId" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="Employees-Employees" msdata:parent="Employees" msdata:child="Employees" msdata:parentkey="EmployeeID" msdata:childkey="ReportsTo" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="tblTime-tblMonthNames" msdata:parent="dbo_tblMonthNames" msdata:child="dbo_tblTime" msdata:parentkey="MonthNumber" msdata:childkey="Month" msprop:Description="" msprop:IsLogical="True" />
        </xs:appinfo>
      </xs:annotation>
    </xs:schema>
    <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" />
  </Schema>
</DataSourceView>
123

northwind.dsv - 源码说明

本页面展示了「&lt; SQL Server2005程序设计&gt;」中的 northwind.dsv 源码文件，采用 DSV 编程语言编写，共 580 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与SQL Server相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?