I have a sql server table with primary key column and a sequence column. I have 2 processes that are going to insert data into this table at the same time. Will this cause any kind of issue, like deadlock?
Please note that both the processes will never insert data with same primary key.
Thanks in advance!