While updating use hint: with (ROWLOCK)

e.g.

UPDATE Test with (ROWLOCK) SET F2 = 'Ant' WHERE F1 = 'A'

Regards,

Salman