?? my sqldb.smdl
字號:
?<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>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -