my sqldb.smdl

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

<SemanticModel ID="G1ce745e5-6c2a-494b-9f8a-31ff60d5133e" xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Culture>zh-CN</Culture>
  <Entities>
    <Entity ID="G71e44f69-3a57-4f6f-afad-d938bb31fdcb">
      <Name>Employees</Name>
      <CollectionName>Employees</CollectionName>
      <IdentifyingAttributes>
        <AttributeReference>
          <!--Emp Name-->
          <AttributeID>G0b024183-13ec-4e3c-80c7-c47a6ccfc501</AttributeID>
        </AttributeReference>
      </IdentifyingAttributes>
      <DefaultDetailAttributes>
        <AttributeReference>
          <!--Emp Name-->
          <AttributeID>G0b024183-13ec-4e3c-80c7-c47a6ccfc501</AttributeID>
        </AttributeReference>
        <AttributeReference>
          <!--Id Card-->
          <AttributeID>G1bc98b8e-64f5-427d-a1d9-67fbbde40069</AttributeID>
        </AttributeReference>
        <AttributeReference>
          <!--Wage-->
          <AttributeID>Gf0e20ce6-65b6-4b3c-839d-ae74dfe4406d</AttributeID>
        </AttributeReference>
        <AttributeReference>
          <!--Title-->
          <AttributeID>G72f9a73a-f835-49f7-bb9c-1ab87b052e77</AttributeID>
        </AttributeReference>
        <AttributeReference>
          <!--Sex-->
          <AttributeID>Gea5d8089-fcfd-4821-9eff-6bde17488d48</AttributeID>
        </AttributeReference>
        <AttributeReference>
          <!--Dep Id-->
          <AttributeID>Gd94a14ab-0ff3-4746-9d89-9f35d72c7d66</AttributeID>
        </AttributeReference>
      </DefaultDetailAttributes>
      <DefaultAggregateAttributes>
        <AttributeReference>
          <!--#Employees-->
          <AttributeID>G5f984ed7-3cf3-4af5-9ae8-494ea781dba2</AttributeID>
        </AttributeReference>
      </DefaultAggregateAttributes>
      <InstanceSelection>Dropdown</InstanceSelection>
      <Fields>
        <Attribute ID="G5f984ed7-3cf3-4af5-9ae8-494ea781dba2">
          <Name>#Employees</Name>
          <DataType>Integer</DataType>
          <Expression>
            <Function>
              <FunctionName>Count</FunctionName>
              <Arguments>
                <Expression>
                  <EntityRef>
                    <!--Employees-->
                    <EntityID>G71e44f69-3a57-4f6f-afad-d938bb31fdcb</EntityID>
                  </EntityRef>
                </Expression>
              </Arguments>
            </Function>
          </Expression>
          <IsAggregate>true</IsAggregate>
          <SortDirection>Descending</SortDirection>
          <Format>n0</Format>
          <EnableDrillthrough>true</EnableDrillthrough>
        </Attribute>
        <Attribute ID="G27cd5bbf-5464-4dd4-83a6-5eb24a6912f3">
          <Name>Emp Id</Name>
          <Hidden>true</Hidden>
          <DataType>Integer</DataType>
          <SortDirection>Descending</SortDirection>
          <Width>3</Width>
          <Format>g</Format>
          <DiscourageGrouping>true</DiscourageGrouping>
          <ValueSelection>Dropdown</ValueSelection>
          <Column Name="Emp_id" />
        </Attribute>
        <Attribute ID="G0b024183-13ec-4e3c-80c7-c47a6ccfc501">
          <Name>Emp Name</Name>
          <DataType>String</DataType>
          <SortDirection>Ascending</SortDirection>
          <Width>2</Width>
          <DiscourageGrouping>true</DiscourageGrouping>
          <EnableDrillthrough>true</EnableDrillthrough>
          <ContextualName>Merge</ContextualName>
          <ValueSelection>Dropdown</ValueSelection>
          <Column Name="Emp_name" />
        </Attribute>
        <Attribute ID="Gea5d8089-fcfd-4821-9eff-6bde17488d48">
          <Name>Sex</Name>
          <DataType>String</DataType>
          <Nullable>true</Nullable>
          <SortDirection>Ascending</SortDirection>
          <Width>1</Width>
          <ValueSelection>Dropdown</ValueSelection>
          <Column Name="Sex" />
        </Attribute>
        <Attribute ID="G72f9a73a-f835-49f7-bb9c-1ab87b052e77">
          <Name>Title</Name>
          <DataType>String</DataType>
          <SortDirection>Ascending</SortDirection>
          <Width>4</Width>
          <ValueSelection>Dropdown</ValueSelection>
          <Column Name="Title" />
        </Attribute>
        <Attribute ID="Gf0e20ce6-65b6-4b3c-839d-ae74dfe4406d">
          <Name>Wage</Name>
          <DataType>Float</DataType>
          <Nullable>true</Nullable>
          <SortDirection>Descending</SortDirection>
          <Width>6</Width>
          <Format>f0</Format>
          <DiscourageGrouping>true</DiscourageGrouping>
          <!--Wage 的总计-->
          <DefaultAggregateAttributeID>G15db20d0-2bde-4a51-8344-c053add15670</DefaultAggregateAttributeID>
          <ValueSelection>Dropdown</ValueSelection>
          <Variations>
            <Attribute ID="G15db20d0-2bde-4a51-8344-c053add15670">
              <Name>Wage 的总计</Name>
              <DataType>Float</DataType>
              <Nullable>true</Nullable>
              <Expression>
                <Function>
                  <FunctionName>Sum</FunctionName>
                  <Arguments>
                    <Expression>
                      <AttributeRef>
                        <!--Wage-->
                        <AttributeID>Gf0e20ce6-65b6-4b3c-839d-ae74dfe4406d</AttributeID>
                      </AttributeRef>
                    </Expression>
                  </Arguments>
                </Function>
              </Expression>
              <IsAggregate>true</IsAggregate>
              <SortDirection>Descending</SortDirection>
              <EnableDrillthrough>true</EnableDrillthrough>
            </Attribute>
            <Attribute ID="G5629a34e-a16a-4505-8276-d01eb590472b">
              <Name>Wage 的平均值</Name>
              <DataType>Float</DataType>
              <Nullable>true</Nullable>
              <Expression>
                <Function>
                  <FunctionName>Avg</FunctionName>
                  <Arguments>
                    <Expression>
                      <AttributeRef>
                        <!--Wage-->
                        <AttributeID>Gf0e20ce6-65b6-4b3c-839d-ae74dfe4406d</AttributeID>
                      </AttributeRef>
                    </Expression>
                  </Arguments>
                </Function>
              </Expression>
              <IsAggregate>true</IsAggregate>
              <SortDirection>Descending</SortDirection>
              <EnableDrillthrough>true</EnableDrillthrough>
            </Attribute>
            <Attribute ID="Gd0ceb4ff-0466-4696-993e-afaac3e2a565">
              <Name>Wage 的最小值</Name>
              <DataType>Float</DataType>
              <Nullable>true</Nullable>
              <Expression>
                <Function>
                  <FunctionName>Min</FunctionName>
                  <Arguments>
                    <Expression>
                      <AttributeRef>
                        <!--Wage-->
                        <AttributeID>Gf0e20ce6-65b6-4b3c-839d-ae74dfe4406d</AttributeID>
                      </AttributeRef>
                    </Expression>
                  </Arguments>
                </Function>
              </Expression>
              <IsAggregate>true</IsAggregate>
              <SortDirection>Descending</SortDirection>
              <EnableDrillthrough>true</EnableDrillthrough>
            </Attribute>
            <Attribute ID="Gd6ef4cdc-7b83-4621-936a-f34ab6c81c4c">
              <Name>Wage 的最大值</Name>
              <DataType>Float</DataType>
              <Nullable>true</Nullable>
              <Expression>
                <Function>
                  <FunctionName>Max</FunctionName>
                  <Arguments>
                    <Expression>
                      <AttributeRef>
                        <!--Wage-->
                        <AttributeID>Gf0e20ce6-65b6-4b3c-839d-ae74dfe4406d</AttributeID>
                      </AttributeRef>
                    </Expression>
                  </Arguments>
                </Function>
              </Expression>
              <IsAggregate>true</IsAggregate>
              <SortDirection>Descending</SortDirection>
              <EnableDrillthrough>true</EnableDrillthrough>
            </Attribute>
          </Variations>
          <Column Name="Wage" />
        </Attribute>
        <Attribute ID="G1bc98b8e-64f5-427d-a1d9-67fbbde40069">
          <Name>Id Card</Name>
          <DataType>String</DataType>
          <SortDirection>Ascending</SortDirection>
          <Width>11</Width>
          <DiscourageGrouping>true</DiscourageGrouping>
          <ValueSelection>Dropdown</ValueSelection>
          <Column Name="IdCard" />
        </Attribute>
        <Attribute ID="Gd94a14ab-0ff3-4746-9d89-9f35d72c7d66">
          <Name>Dep Id</Name>
          <DataType>Integer</DataType>
          <SortDirection>Descending</SortDirection>
          <Width>2</Width>
          <Format>g</Format>
          <ValueSelection>Dropdown</ValueSelection>
          <Column Name="Dep_id" />
        </Attribute>
      </Fields>
      <Table Name="dbo_Employees" />
    </Entity>
  </Entities>
</SemanticModel>