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 |
|
bigorno
Starting Member
2 Posts |
 Posted - 2002-06-27 : 08:36:06
|
| Since inserting an item in a nested-set based tree meansmodifying left/right for a good deal of other items, shouldn'tthe table be locked during the insert?It seems that the "lineage" method does not require this?Locking hasn't been mentionned in the discussion: is it a problemafter all?Stephen |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-07-01 : 19:59:19
|
| check your other post for an answer...--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-07-01 : 20:00:16
|
| sorry - couldn't resist - I thought I was seeing double.sorry - couldn't resist - I thought I was seeing double.If you're doing your update as a stored procedure call, you won't have to worry about locking...check out "Understanding Locking in SQL Server" in BOL (books on-line). If however you're trying to do it from your web-page VBS or other, you're in for a fun ride...Edited by - rrb on 07/01/2002 20:08:21 |
|
|
|
|
|
|
Locking?