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 |
|
pramod21
Yak Posting Veteran
64 Posts |
 Posted - 2012-09-18 : 01:37:12
|
| HI,there is a table in my database on which multiple user are using at same time, In my procedure two condition is there: 1st> it will check the data by using select statement if it is greater then 0 then it will subtract few amount in that data.now problem is if two user are selecting the data they both can see the same number and after that 1st user subtract some data and in another second 2nd user subtract some data in this case 2nd user is getting wrong data bcoz he was not aware of the 1st user. how to solve this??thanks |
|
|
|
|
|
transaction isolation