How to apply hint to update stmt?

[sqlsadie108]

Hi,

How and where do I apply the WITH (maxdop=1) hint to an update stmt? I am looking for the correct syntax.

example - similar to my query in structure)
UPDATE myTable a
SET col1 = x, col2 = y, col3 = b -- complexity hidden
FROM myTable b
LEFT JOIN anotherTable...

Thanks much

 

[ptheriault]

Like this.

UPDATE myTable a
SET col1 = x, col2 = y, col3 = b -- complexity hidden
FROM myTable b
LEFT JOIN anotherTable
OPTION (MAXDOP 1)

- Paul
- If at first you don't succeed, find out if the loser gets anything.