Home Forums SQL Server 7,2000 Performance Tuning Set Transaction Isolation Level for UPDATE or DELETE statements RE: Set Transaction Isolation Level for UPDATE or DELETE statements

  • November 8, 2007 at 1:27 pm

    #749628

    The answer is YES, the Set Transaction Isolation Level works for the joined tables in the UPDATE statement, I couldn't found an answer in books or pages in internet, I had to prove myself

    Also, It works for the joined tables in DELETE and INSERT statements, even Subqueries used in any of these statements

    I hope this be helpful