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.
| Author |
Topic |
|
kareem100
Starting Member
10 Posts |
 Posted - 2010-03-06 : 17:48:42
|
| Hi,Does anyone know how SQL handles multiple users attempting to amend/delete the same record at the same time. For example if user a and b retrieve the same record at the same time.If user adds 10 to the acc balance ( sets it to £100 ), then user b adds another 10 to the balance of the same record ( sets it to £100 ). Obviously in this example the updates has not been correctly administered.Does sql lock the records.Regards,Kareem. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-06 : 20:15:31
|
| that's exactly what it doeshave a look at this: http://msdn.microsoft.com/en-us/library/ms175519.aspx |
 |
|
|
|
|
|
how does sql handle mutliple users accessing same