Update with Nolock

[sendba]

hai all

I have an update problem .Please help me
Let me know whether i can use nolock in the update statement as given below


update a
set a.nproductid = b.Productid
from db1..tb1 a with (nolock)
inner join db2..tb2 b with (nolock)
on a.col1 = b.col1


thanks in advance

Sen

 

[SQLDenis]

you can,
however the posibility of dirty, repeatable and phantom reads exists and you might get data corruption which will be a very BIG pain in the neck to fix later on

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Catadmin]

You can try, but I don't think it'll work. AFAIK, Update requires the ability to lock something (record or table) depending on what kind of update you're doing.

You might be able to use With (Nolock) on the table you are not updating (Table B), but I wouldn't recommend using it on Table A.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"