Multithreaded App with MSSQL
Posted on 2010-11-29
I've got a multitheaded application using MSSQL.
This question has been simplified to avoid confusion.
If I program 10 threads to do the following 10,000 times:-
UPDATE tblTest SET fCounter=fCounter+1
..can I be sure that fCounter will always equal 100,000 at the end even though its getting the command hundreds of times per second?
Is there a setting I need to change that will force SQL server to keep track of things properly?