no the script is just an example the query has different column and table name.

well i want to know is that will that Nolock will be helpful or not for that particular join update query!!

if it is not useful then why ?