Question Getting deadlock issue during update query.

[Kiran kari]

Please let me know how to fix. Is nolock will work for update query?

 

[jmcilhinney]

Fix what? A deadlock can occur for any number of reasons. If we can't see what you're doing, we can't see what you're doing wrong. Please post the code but ONLY the relevant code, along with an explanation of exactly what you're trying to achieve.

 

[Kiran kari]

Update C set last_date = Getdate(),
data = 'Not implemented'
from dbo.employee_data As C
innerjoin #covered As D on C.item_id = D.item_id
Option (Maxdop 1)

 

[Skydiver]

Does the SQL analyzer provide any hints as to what maybe causing the deadlock?