TableHintKind Enumeration
Definition
Wichtig
Einige Informationen beziehen sich auf Vorabversionen, die vor dem Release ggf. grundlegend überarbeitet werden. Microsoft übernimmt hinsichtlich der hier bereitgestellten Informationen keine Gewährleistungen, seien sie ausdrücklich oder konkludent.
Die Tabellenhinweise.
[System.Serializable]
public enum TableHintKind[<System.Serializable>]
type TableHintKind = Public Enum TableHintKind- Vererbung
-
TableHintKind
- Attribute
Felder
| Name | Wert | Beschreibung |
|---|---|---|
| None | 0 | Nichts wurde verwendet. |
| FastFirstRow | 1 | FASTFIRSTROW-Schlüsselwort. |
| HoldLock | 2 | HOLDLOCK-Schlüsselwort. |
| NoLock | 3 | NOLOCK-Schlüsselwort. |
| PagLock | 4 | PAGLOCK-Schlüsselwort. |
| ReadCommitted | 5 | READCOMMITTED-Schlüsselwort. |
| ReadPast | 6 | READPAST-Schlüsselwort. |
| ReadUncommitted | 7 | READUNCOMMITTED-Schlüsselwort. |
| RepeatableRead | 8 | SCHLÜSSELwort REPEATABLEREAD. |
| Rowlock | 9 | ROWLOCK-Schlüsselwort. |
| Serializable | 10 | SERIALIZABLE-Schlüsselwort. |
| TabLock | 11 | TABLOCK-Schlüsselwort. |
| TabLockX | 12 | TABLOCKX-Schlüsselwort. |
| UpdLock | 13 | UPDLOCK-Schlüsselwort. |
| XLock | 14 | XLOCK-Schlüsselwort. |
| NoExpand | 15 | NOEXPAND-Schlüsselwort. |
| NoWait | 16 | NOWAIT-Schlüsselwort. |
| ReadCommittedLock | 17 | READCOMMITTEDLOCK-Schlüsselwort. |
| KeepIdentity | 18 | KEEPIDENTITY-Schlüsselwort. |
| KeepDefaults | 19 | KEEPDEFAULTS-Schlüsselwort. |
| IgnoreConstraints | 20 | IGNORE_CONSTRAINTS Schlüsselwort. |
| IgnoreTriggers | 21 | IGNORE_TRIGGERS Schlüsselwort. |
| ForceSeek | 22 | FORCESEEK-Schlüsselwort. |
| Index | 23 | INDEX-Tabellenhinweis |
| SpatialWindowMaxCells | 24 | SPATIAL_WINDOW_MAX_CELLS Tabellenhinweis |
| ForceScan | 25 | FORCESCAN-Schlüsselwort. |
| Snapshot | 26 | SNAPSHOT-Schlüsselwort |