The Database Forum

#1 (permalink)

hi,

Please can someone tell me how to change the following SP into a Try/Catch to avoid deadlocking?

ALTER PROCEDURE [dbo].[SP_UpdateUserIPandTime](@User_ID INT,@IP nvarchar (16))
AS UPDATE dbo.TABLENAME
SET COLUMNNAME1 = GETDATE(), COLUMNNAME2 = @IP
WHERE (COLUMNNAME3 = @User_ID)

I'm tearing my hair out trying to work it out.

Thanks so much