sql server - Do table hints apply to all tables or only the preceding table? -


if have

select * tablea, tableb (nolock) 

does nolock hint apply tableb, or apply both tables? need do

select * tablea (nolock), tableb (nolock) 

for hint apply both tables?

table hints apply preceeding table. need

select * tablea (nolock), tableb (nolock) 

Comments

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -