my sqldb.dsv

精通SQL Server 2005数据库应用系统开发 立即下载 的 4.5.6.7.8.9章的内容代码写的很好 谢谢

<DataSourceView xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <ID>My SQLDB</ID>
  <Name>My SQLDB</Name>
  <Annotations xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
      <Value>true</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CurrentLayout</Name>
      <Value>_ALL_TABLES_</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:NameMatchingCriteria</Name>
      <Value>1</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:SchemaRestriction</Name>
      <Value>
      </Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:RetrieveRelationships</Name>
      <Value>true</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:Layouts</Name>
      <Value>
        <Layouts xmlns="">
          <Diagram>
            <Name>_ALL_TABLES_</Name>
            <DiagramLayout />
            <ShowRelationshipNames>False</ShowRelationshipNames>
            <UseDiagramDefaultLayout>True</UseDiagramDefaultLayout>
            <DiagramViewPortLeft>0</DiagramViewPortLeft>
            <DiagramViewPortTop>0</DiagramViewPortTop>
            <DiagramBoundingLeft>0</DiagramBoundingLeft>
            <DiagramBoundingTop>0</DiagramBoundingTop>
            <DiagramZoom>100</DiagramZoom>
          </Diagram>
        </Layouts>
      </Value>
    </Annotation>
  </Annotations>
  <DataSourceID>My SQLDB</DataSourceID>
  <Schema>
    <xs:schema id="My_x0020_SQLDB" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
      <xs:element name="My_x0020_SQLDB" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:design-time-name="559c3a90-a76b-47c1-883a-565d2cc2ff25" msprop:CompareInfo="&lt;CompareInfo&gt;&lt;Culture&gt;zh-CN&lt;/Culture&gt;&lt;IgnoreCase&gt;true&lt;/IgnoreCase&gt;&lt;IgnoreKanaType&gt;true&lt;/IgnoreKanaType&gt;&lt;IgnoreWidth&gt;true&lt;/IgnoreWidth&gt;&lt;/CompareInfo&gt;">
        <xs:complexType>
          <xs:choice minOccurs="0" maxOccurs="unbounded">
            <xs:element name="dbo_Departments" msprop:FriendlyName="Departments" msprop:DbTableName="Departments" msprop:DbSchemaName="dbo" msprop:stats_RowCount="5" msprop:design-time-name="7c7331a5-5db2-4fb6-a1a6-58247d18f938" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="dep_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:stats_StDevWidth="0.4472136" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="dep_id" msprop:design-time-name="16204de6-ceb0-4759-accd-0525ce768c11" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="5" msprop:stats_AvgWidth="1.2" msprop:DbColumnName="dep_id" type="xs:int" />
                  <xs:element name="dep_name" msprop:stats_StDevWidth="0.8944272" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="dep_name" msprop:design-time-name="cfa4679a-0fb6-43ac-9331-7d6c84ae624a" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="5" msprop:stats_AvgWidth="3.4" msprop:DbColumnName="dep_name">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="100" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_Employees" msprop:FriendlyName="Employees" msprop:DbTableName="Employees" msprop:DbSchemaName="dbo" msprop:stats_RowCount="8" msprop:design-time-name="409987df-7cbb-4501-a786-49e6d77b9d74" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="Emp_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:stats_StDevWidth="0.3535534" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="Emp_id" msprop:design-time-name="f4f4b4ba-7cd1-4aa8-a2a5-4e46423b41c4" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="8" msprop:stats_AvgWidth="1.125" msprop:DbColumnName="Emp_id" type="xs:int" />
                  <xs:element name="Emp_name" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="Emp_name" msprop:design-time-name="88bc7b37-f440-4274-8b29-100fa4924d45" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="8" msprop:stats_AvgWidth="2" msprop:DbColumnName="Emp_name">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Sex" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="25" msprop:FriendlyName="Sex" msprop:design-time-name="8c0040f0-7d89-4ded-9d83-94cd7cb59873" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="2" msprop:stats_AvgWidth="1" msprop:DbColumnName="Sex" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="2" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Title" msprop:stats_StDevWidth="1.035098" msprop:stats_UniqueValuePercent="25" msprop:FriendlyName="Title" msprop:design-time-name="0f3a04df-c26c-405d-80c7-86d51ceb58d9" msprop:stats_MaxWidth="4" msprop:stats_UniqueValueCount="2" msprop:stats_AvgWidth="2.75" msprop:DbColumnName="Title">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Wage" msprop:stats_StDevWidth="0" msprop:stats_AvgScale="0" msprop:stats_UniqueValuePercent="87" msprop:FriendlyName="Wage" msprop:design-time-name="81afa402-8b84-4daa-b773-a31093600cf5" msprop:stats_StDevScale="0" msprop:stats_MaxWidth="4" msprop:stats_UniqueValueCount="7" msprop:stats_MaxScale="0" msprop:stats_AvgWidth="4" msprop:DbColumnName="Wage" type="xs:double" minOccurs="0" />
                  <xs:element name="IdCard" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="IdCard" msprop:design-time-name="78935228-9d89-4654-abce-1070902ba097" msprop:stats_MaxWidth="11" msprop:stats_UniqueValueCount="8" msprop:stats_AvgWidth="11" msprop:DbColumnName="IdCard">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="20" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Dep_id" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="37" msprop:FriendlyName="Dep_id" msprop:design-time-name="89b5e4f5-a9f5-4b43-83a7-145d14ab4656" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="3" msprop:stats_AvgWidth="1" msprop:DbColumnName="Dep_id" type="xs:int" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:choice>
        </xs:complexType>
        <xs:unique name="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_Employees" />
          <xs:field xpath="Emp_id" />
        </xs:unique>
      </xs:element>
    </xs:schema>
  </Schema>
</DataSourceView>