Programmierung
Programmierung
|
Administration •
Links •
Vorgehensmodelle •
NuGet •
Transformations •
MSBuild •
Raspberry •
Cheatsheets •
Git •
Mathematica
|
C♯
|
|
F♯
|
|
Python
|
Classes •
Loops •
Anonymous Types •
Lambda Expressions •
Queries (LINQ) •
Iterators (yield)
|
PHP
|
|
T-SQL / SQL Server
|
T-SQL Fundamantals
|
Select •
Programming •
Pitfalls •
Query from Multiple Tables •
Groups and Summaries •
Advanced Select •
Aggregation and Windowing •
Insert, Update, Delete •
Strings •
Date and Time •
Numbers •
Transactions, Locking, Blocking, Deadlock •
Tables •
Views •
Large Tables and Databases •
Indexes •
Stored Procedures •
User-Defined Functions and Types •
Triggers •
Error Handling •
Query Performance and Tuning •
Hints •
Index Tuning and Statistics •
XML •
Files, Filegroups, Integrity •
Backup •
Recovery •
Principals and Users •
Securables, Permissions, Auditing •
Objects and Dependencies
|
SQL Server Performance Tuning
|
Memory Performance Analysis •
Disk Performance Analysis •
CPU Performance Analysis •
Baseline Creation •
Query Performance Metrics •
Query Performance Analysis •
Index Architecture and Behavior •
Index Analysis •
Database Engine Tuning Advisor •
Key Lookups •
Statistics, Data Distributuon, and Cardinality •
Index Fragmentation •
Execution Plan Generation •
Execution Plan Cache Behavior •
Parameter Sniffing •
Query Recompilation •
Query Design Analysis •
Reduce Query Resource Use •
Blocking and Blocked Processes •
Causes and Solutions for Deadlocks •
Row-By-Row Processing •
Memory-Optimized OLTP Tables and Procedures •
Database Performance Testing •
Database Workload Optimization •
SQL Server Optimization Checklist
|
Service Broker
|
Message •
Contract •
Queue •
Service •
.NET Integration •
Route •
Security
|
|
Datatypes •
Unit Testing •
Dependency Injection •
Partitioning •
|
|
.NET
|
|
ASP.NET
|
|
Messaging
|
|
User Interface
|
|
Parallel Programming
|
|
ECMAScript
|
|
SharePoint
|
|
Microsoft CRM
|
Reporting and Dashboards •
SharePoint Integration •
Authentication •
Entity Handling •
Workflows •
Queries
|
Security
|
Forms Authentication •
Membership and Role Provider •
Zertifikate •
OAuth •
OpenID •
Windows Identity Foundation
|
Dateiformate
|
CSV •
Excel •
Word •
PDF •
Email
|
Azure
|
|
Muster
|
|
Powershell
|
|
Android
|
ROM Flashen •
Unit Testing •
Assistant
|
Machine Learning
|
|
Core Server
|
Hyper-V •
Active Directory User Groups •
Active Directory Domain Services •
Active Directory Federation Services •
DHCP •
IIS •
DNS •
RDP •
WSUS •
User Permissions •
IP •
SMB •
DHCP •
IPAM •
Sonstige
|
Bot Framework
|
Rich Messages •
|
FieldTypes
SPFieldType |
Class |
Declarative Example[1]
|
Invalid |
— |
—
|
Integer |
|
<Field SourceID="http://schemas.microsoft.com/sharepoint/3.0"
ID="{GUID}"
Name="XxxId"
DisplayName="Xxx ID"
Type="Numeric"
Commas="FALSE"
Decimals="0"
ReadOnly="TRUE"
Sealed="FALSE"
Required="TRUE"
Hidden="FALSE"
Group="..."></Field>
|
Text |
SPFieldText |
<Field ID="{GUID}"
Name="TaskStatusField"
StaticName="TaskStatusField"
SourceID="http://schemas.microsoft.com/sharepoint/v3"
Group="MyCompany"
DisplayName="Task Status"
Type="Text"
Required="FALSE"></Field>
|
Note |
SPFieldMultiLineText |
|
DateTime |
SPFieldDateTime |
<Field ID="{GUID}"
Name="...Field"
StaticName="...Field"
SourceID="http://schemas.microsoft.com/sharepoint/v3"
Group="MyGroup"
DisplayName="..."
Type="DateTime"
Required="FALSE"
Format="DateTime"
StorageTZ="UTC"
ShowInEditForm="TRUE"
ShowInNewForm="TRUE"
ShowInDisplayForm="TRUE"
ShowInVersionHistory="TRUE"></Field>
|
Counter |
|
|
Choice |
SPFieldChoice
|
<Field ID="{GUID}"
Name="...Field"
StaticName="...Field"
DisplayName="..."
Group="MyCompany"
SourceID="http://schemas.microsoft.com/sharepoint/v3"
Type="Choice"
Required="FALSE">
<CHOICES>
<CHOICE>A</CHOICE>
<CHOICE>B</CHOICE>
<CHOICE>C</CHOICE>
</CHOICES>
</Field>
|
Lookup |
SPFieldLookup |
<Field ID="{2FF1B484-6D70-449c-8E5C-904E4D5971E1}"
Name="Leader"
Group="My Custom Columns"
Type="Lookup"
DisplayName="Leader"
List="Lists/Leaders"
ShowField="Title"
PrependId="TRUE" />
|
Boolean |
SPFieldBoolean |
|
Number |
SPFieldNumber |
<Field ID="{GUID}"
Name="SourceVersionField"
StaticName="SourceVersionField"
SourceID="http://schemas.microsoft.com/sharepoint/v3"
Group="MyCompany"
DisplayName="Source Version"
Type="Number"
Required="FALSE"></Field>
|
Currency |
SPFieldCurrency |
|
URL |
SPFieldUrl |
|
Computed |
SPFieldComputed |
|
Threading |
|
|
Guid |
|
|
MultiChoice |
SPFieldMultiChoice |
|
GridChoice |
SPFieldRatingScale |
|
Calculated |
SPFieldCalculated |
|
File |
SPFieldFile |
|
Attachments |
SPFieldAttachments |
|
User |
SPFieldUser |
<Field Type="User"
DisplayName="..."
List="...."
Required="FALSE"
ShowField="ImnName"
UserSelectionMode="PeopleOnly"
UserSelectionScope="0"
ID="{5126526F-3A77-42BF-B1EF-D3F025B1442F}"
SourceID="http://schemas.microsoft.com/sharepoint/v3"
StaticName="..."
Name="..."
Group="MyCompany"
Mult="TRUE"
Sortable="FALSE"
Version="1"></Field>
|
Recurrence |
SPFieldRecurrence |
|
CrossProjectLink |
SPFieldCrossProjectLink |
|
ModStat |
SPFieldModStat |
|
Error |
|
|
ContentTypeId |
|
|
PageSeparator |
SPFieldPageSeparator |
|
ThreadIndex |
|
|
WorkflowStatus |
SPFieldWorkflowStatus |
|
AllDayEvent |
SPFieldAllDayEvent |
|
WorkflowEventType |
|
|
Geolocation |
|
|
OutcomeChoice |
|
|
MaxItems |
|
|
(Custom Type) |
|
<Field Type="UserMulti"
DisplayName="..."
List="...."
Required="FALSE"
ShowField="ImnName"
UserSelectionMode="PeopleOnly"
UserSelectionScope="0"
ID="{GUID}"
SourceID="http://schemas.microsoft.com/sharepoint/v3"
StaticName="..."
Name="..."
Group="MyCompany"
Mult="TRUE"
Sortable="FALSE"
Version="1"></Field>
|
Field Attributes[2]
Attributes |
Values
|
Text
|
MultiLineText
|
DateTime
|
Choice
|
Lookup
|
Boolean
|
Number
|
Currency
|
Url
|
Computed
|
MultiChoice
|
RatingScale
|
Calculated
|
File
|
Attachments
|
User
|
Recurrence
|
CrossProjectLink
|
ModStat
|
PageSeparator
|
WorkflowStatus
|
AllDayEvent
|
Aggregation (AggregationFunction) |
sum, count, average, min, max, merge, plaintext, first, last |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
AllowDeletion |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
AllowDuplicateValues |
TRUE, FALSE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AllowHyperlink |
TRUE, FALSE |
N |
J |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N
|
AllowMultiVote |
TRUE, FALSE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AppendOnly |
TRUE, FALSE |
N |
J |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N
|
AuthoringInfo |
Text |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
BaseType |
Text |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CalType (CalendarType) |
Integer |
N |
N |
J |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N
|
CanToggleHidden |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
ClassInfo |
Text |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ColName |
Text |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Commas |
TRUE, FALSE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Customization |
Text |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Decimals |
Integer |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DefaultListField |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
Description |
Text |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
Dir (Direction) |
Text |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
DisplaceOnUpgrade |
TRUE, FALSE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DisplayImage |
Text |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DisplayName |
Text |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
DisplayNameSrcField |
Text |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DisplaySize |
Integer |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
Div |
Number |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EnableLookup |
TRUE, FALSE |
N |
N |
N |
N |
N |
N |
N |
N |
N |
J |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N
|
ExceptionImage |
Text |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
FieldRef |
Text |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
FillInChoice |
TRUE, FALSE |
N |
N |
N |
J |
N |
N |
N |
N |
N |
N |
J |
J |
N |
N |
N |
N |
N |
N |
J |
N |
J |
N
|
Filterable |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
FilterableNoRecurrence |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
ForcedDisplay |
Text |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Format |
DateOnly, DateTime, TimeOnly, EventList, ISO8601, MonthDayOnly, MonthYearOnly, ISO8601Basic, ISO8601Gregorian, ISO8601BasicDateOnly, DropDown, RadioButtons, HyperLink, Image, TRUE, FALSE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
FromBaseType |
TRUE, FALSE |
|
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
Group |
Text |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
HeaderImage |
Text |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Height |
Integer |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Hidden |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
HTMLEncode |
TRUE, FALSE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ID |
GUID |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
IMEMode |
inactive |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
Indexed |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
IsolateStyles |
TRUE, FALSE |
N |
J |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N
|
IsRelationship |
TRUE, FALSE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
JoinColName |
Text |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
JoinRowOrdinal |
Integer |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
JoinType |
LEFT OUTER | RIGHT OUTER |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
LCID |
Integer |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
LinkToItem |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
|
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
List (ParentList) |
Text |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
Max (MaximumValue) |
Number |
N |
N |
N |
N |
N |
N |
J |
J |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N
|
MaxLength |
Integer |
J |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N
|
Min (MinimumValue) |
Number |
N |
N |
N |
N |
N |
N |
J |
J |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N
|
Mult (AllowMultipleValues) |
TRUE, FALSE |
N |
N |
N |
N |
J |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
J |
N |
N |
N |
N |
N |
N
|
Name (InternalName) |
Text |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
NegativeFormat |
Parens |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Node (NodeChoices) |
Text |
N |
N |
N |
J |
N |
N |
N |
N |
N |
N |
N |
J |
N |
N |
N |
N |
N |
N |
J |
N |
J |
N
|
NoEditFormBreak |
TRUE, FALSE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
NumLines (NumberOfLines) |
Integer |
N |
J |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N
|
Overwrite |
TRUE, FALSE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OverwriteInChildScopes |
TRUE, FALSE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Percentage (ShowAsPercentage) |
TRUE, FALSE |
N |
N |
N |
N |
N |
N |
J |
J |
N |
J |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N
|
PIAttribute |
Text |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
PITarget |
Text |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
PrependId |
TRUE, FALSE |
|
|
Presence |
TRUE, FALSE |
|
|
PrimaryKey |
TRUE, FALSE |
|
|
PrimaryPIAttribute |
Text |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
PrimaryPITarget |
Text |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
ReadOnly |
TRUE, FALSE |
|
|
ReadOnlyEnforced |
TRUE, FALSE |
|
|
RelationshipDeleteBehavior |
Cascade | None |
|
|
RenderXMLUsingPattern |
TRUE, FALSE |
|
|
Required |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
RestrictedMode |
TRUE, FALSE |
|
J
|
ResultType |
Text |
|
|
RichText |
TRUE, FALSE |
|
J
|
RichTextMode |
Text |
|
J
|
RowOrdinal |
Integer |
|
|
Sealed |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
SeperateLine |
TRUE, FALSE |
|
|
SetAs |
Text |
|
|
ShowAddressBookButton |
TRUE, FALSE |
|
|
ShowField |
Choice | Counter |
|
|
ShowInDisplayForm |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
ShowInEditForm |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
ShowInFileDlg |
TRUE, FALSE |
|
|
ShowInListSettings |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
ShowInNewForm |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
ShowInVersionHistory |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
ShowInViewForms |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
Sortable |
TRUE, FALSE |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
SourceID |
URI |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
StaticName |
Text |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
StorageTZ |
Abstract |
|
|
StripWS |
TRUE, FALSE |
|
|
SuppressNameDisplay |
TRUE, FALSE |
|
|
TextOnly |
TRUE, FALSE |
|
|
Title |
Text |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
Type |
Data_Type |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J |
J
|
UniqueId |
Text |
|
|
UnlimitedLengthInDocumentLibrary |
TRUE, FALSE |
|
J
|
URLEncode |
TRUE, FALSE |
|
|
URLEncodeAsUrl |
TRUE, FALSE |
|
|
UserSelectionMode |
Text |
|
|
UserSelectionScope |
Integer |
|
|
Viewable |
TRUE, FALSE |
|
|
Width |
Integer |
|
|
WikiLinking |
TRUE, FALSE |
|
J
|
XName |
Text |
|
|
- ↑ Fello Crafter: Sharepoint Field Types - Elements.xml. 10. August 2011, abgerufen am 5. Mai 2014 (englisch).
- ↑ Field Element (Field). In: MSDN, Office Dev Center. Microsoft, abgerufen am 20. April 2014 (englisch).
|