If I need to update same row with two concurrent thread then is it possible in SQL Server?
Suppose I have one table that contains
Name columns and now I want to update the third number Id with Name 'xyz' using one thread. Using the other thread, I want to update the same name which I am updating using the first thread, but it gives error like your connection is in connecting state. I can't update the data.
Does anyone know how to solve it? Do I need to assign a lock?