Thanks:-), Anther question. How to write a SQL coding to check the table is no locking.

i wrote this:

RETRY: --lebel

BEGIN TRANSACTION

BEGIN TRY

UPDATE country ...

I have find the deadlock issue on updating but i want to the the processing repeat when dead lock occur.