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 |
|
dorothy2010
Starting Member
2 Posts |
 Posted - 2010-11-15 : 18:44:45
|
Hi everyoneI got a question regards to concurrency.I am making a multi user application with sql server 2008the application function:insert - bulk of data to the tblA at a time (frequently).views - the view includes part of tblA data, base on that view, user select the records that they want from that views.question:when the user is getting data from the view, at the same time new data add to the tblA. The table got the new data all the time, so the view would change also. What is going to happen when insert and select happenn at the same time.That will be great if any one can give me an idea! thx |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dorothy2010
Starting Member
2 Posts |
Posted - 2010-11-15 : 19:06:03
|
| iam new in this area(concurrency)what situation is in that case?i read alot about locking and concurrency stafit's all mention in table not view, so im not sure if i put a lock on transtion (in table or view), it's going to block.i have not enough information to work out a solution. |
 |
|
|
|
|
|
concurrency question in sql server 2008