Forum Discussion
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...
No error is thrown.Mister_Gregory that's old syntax from Sybase time; that syntax is deprecated and one should avoid them.
Also you should always use the WITH keyword in combination with table/query hints, see
SQL Server, Deprecated Features object - SQL Server | Microsoft Learn
=> Table hint without WITH
No error is thrown.
Mister_Gregory that's old syntax from Sybase time; that syntax is deprecated and one should avoid them.
Also you should always use the WITH keyword in combination with table/query hints, see
SQL Server, Deprecated Features object - SQL Server | Microsoft Learn
=> Table hint without WITH
olafhelper - Thank you very much!