In my application, there are 2 programs inserting data into a table and another process which selects and updates data from the same table.

When all the 3 processes are run at the same time the insert statements produce a deadlock.

Can anybody let me know if I can use some table hint, say ROWLOCK or PAGLOCK with the insert statement? Or is there is some way to prevent the deadlocks from occuring?