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

delphi - ESC/P programming! -

c++ - error: use of deleted function -

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