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 |
|
delete469
Starting Member
2 Posts |
 Posted - 2007-06-03 : 01:49:47
|
| hi everyone,is that possible to access a table if the table is doing an insert command? im trying to insert data into a data while another function calling select statement on that same table. will the table be lock when its doing an insertion? or its free? sorry about the question structure.cheers,delete469 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-03 : 01:59:59
|
| Depends on locking level (table, page, or row level locking). |
 |
|
|
delete469
Starting Member
2 Posts |
Posted - 2007-06-03 : 02:15:01
|
| thx alot. |
|
|
|
|
|
|
help on Mutli Access to a single same Table