Table Hints (Level 2)

Installing SQL Server

Installing SQL Server
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