Enum TableHintLimited
public enum TableHintLimited
Fields
| FASTFIRSTROW | Specifies that the query should be optimized to return the first row quickly - equivalent to a query hint of OPTION (FAST 1). Note that this feature will be removed in the next version of SQL Server. |
| HOLDLOCK | Specified that shared locks must be held until end of transaction rather than just until they are no longer needed - equivalent to SERIALIZABLE. |
| IGNORE_CONSTRAINTS | During a bulk insert operation, specifies that constraints should not be evaluated on inserted rows. |
| IGNORE_TRIGGERS | During a bulk insert operation, specifies that triggers should not be fired on inserted rows. |
| KEEPDEFAULTS | During a bulk insert operation, specifies that default values should be used in place of NULL for row columns that lack a value. |
| KEEPIDENTITY | During a bulk insert operation, specifies that values supplied in the insert statement for identity columns will be used rather than being automatically assigned by the database engine. |
| NOWAIT | Specifies that the operation should generate a message immediately upon discovering a lock - equivalent to setting lock timeout to 0. |
| PAGLOCK | Specifies that a page lock should be taken rather than a row, key, or table lock. |
| READCOMMITTED | Specifies that locking or row versioning will be used to conform to READ COMMITTED isolation level. |
| READCOMMITTEDLOCK | Specifies that locking will be used to conform to READ COMMITTED isolation level. |
| READPAST | Specifies that rows that are locked by other transactions should not be read. This causes both row-level and page-level locks to be skipped. |
| READUNCOMMITTED | Specifies that reads of uncommitted or dirty data is permitted. |
| REPEATABLEREAD | Specifies that locking will be used to conform to REPEATABLE READ isolation level. |
| ROWLOCK | Specifies that a row lock should be taken rather than a page or table lock. |
| SERIALIZABLE | Specified that shared locks must be held until end of transaction rather than just until they are no longer needed - equivalent to HOLDLOCK. |
| TABLOCK | Specifies that until the end of the statement, a shared lock will be taken on the table. |
| TABLOCKX | Specifies that until the end of the statement, an exclusive lock will be taken on the table. |
| UPDLOCK | Specifies that until the end of the transaction, an update lock will be taken on the table. |
| XLOCK | Specifies that whatever locks are specified by ROWLOCK, PAGLOCK, or TABLOCK will be made exclusive until the end of the transaction. |