I know if I use the "Set Transaction Isolation Level" (using Read Uncommitted, or Read Committed, or whatever), l don't need to write lock hints in every table used in every SELECT statement.
I read in a page that it works only for SELECT statements, but an UPDATE statement can have joined several tables and I want to avoid of using Lock hints in every joined table
Check the following example:
Set Transaction Isolation Level Read Uncommitted
Update EmployeeSalaries WITH (RowLock,ReadCommitted) Set
DailySalary = DailySalary * 1.15
Inner Join Employees On Employees.EmpID = EmployeeSalaries.EmpID
Inner Join Departments On Departments.DepartmentID = Employees.DepartmentID
Where Employees.DepartmentName = 'HR'
Using the example, I want to know if the Set Transaction Isolation Level READ UNCOMMITTED works for all the tables joined in this UPDATE statement (Employees and Departments)?