Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  How to serialize concurrent connections?

Author  Topic  BSLillo Starting Member 9 Posts Posted - 2005-12-13 : 04:37:36 Hello everyone! I'm new and i have a problem...i would like to serialize some (about 50 or more) threads which update a record in my SQL Table. I'm using MS SQL Server, but i'm not able doing this...in what way could i operate? Do i have to write something like : BEGIN TRANSACTION ... select.. .... update... ... COMMIT TRANSACTION I would like that when a thread enters in a transaction in order to make an update, noone should read the value not yet affected by the update...in other words i would like to serialize concurrent threads connections in a table... in what way? I wrote two C-like programs which use two different ODBc and the i've run them toghether in order to see what happens...but i notice that there is no seriaization.. what is the exact sintax or code for doing this? Please help me!!! Thank you very much in advance!!!