June 14, 2006 at 12:23 pm
Good afternoon-
I know that setting the transaction level isolation to READ UNCOMMITTED allows dirty reads, etc...what I am not sure of is if this means anything when using an INSERT INTO...SELECT or UPDATE statement vs an ordinary SELECT...in other words, I guess, does the INSERT INTO...SELECT and/or UPDATE ignore the isolation level?
Thanks!
JM
June 14, 2006 at 3:36 pm
According to BOL:
"READUNCOMMITTED, and NOLOCK, cannot be specified for tables modified by insert, update, or delete operations. The SQL Server query optimizer ignores the READUNCOMMITTED and NOLOCK hints in the FROM clause that apply to the target table of an UPDATE or DELETE statement."
June 17, 2006 at 7:09 am
I'd recommend that, whatever you do, you do NOT use "Set Transaction Isolation Level" in updatable views... don't know when it will happen but you will eventually run across an isolation level conflict, if you do.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply