Export (0) Print
Expand All

Table Hints (Level 2)

Table Hints (Level 2)
SQL Server 6.x SQL Server 2000
These table hints (previously called optimizer hints) could be specified as just the keyword following the FROM clause:

FASTFIRSTROW,
HOLDLOCK,
INDEX,
NOLOCK,
PAGLOCK,
TABLOCK,
TABLOCKX,
and UPDLOCK.

Table hints must be specified following the FROM clause using a WITH clause. Table hints must be enclosed in parentheses.

Expect different results as compared to earlier versions of SQL Server. For more information, see DELETE, FROM, INSERT, SELECT, and UPDATE


Show:
© 2014 Microsoft