Forum Discussion

Mister_Gregory's avatar
Mister_Gregory
Copper Contributor
Jan 02, 2024
Solved

Table Hint Position in From Clause

The documentation (https://learn.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver16) for the FROM clause syntax shows the table hints after the table alias. I have recently come across a few queries in which the developer put a nolock hint between the table name and the alias, e.g., FROM dbo.Customer (nolock) cst. No error is thrown. I do not have access to view query plans.

 

Do table hints placed between the table name and alias do anything?

 

Thank you.

2 Replies

Resources