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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-09 : 18:11:24
|
Farouk writes "Hello all,
I was wondering if somebody could give me feedback on the following questions, (no code):
1. Different types of locks and, there functionality?
2. If you use a cursor, with a for update statement, does it lock the row for updating automatically?
3. When you do an update, does sequel automatically lock the row and, what lock is it?
4. When using the for update statement with cursors, are you allowed to update any field in the table, or are you limited to the field the select statement is based on?
5. The sql statements select, update, insert and delete, what are the default locks that sql has assigned to them?
Any form of input would be greatly appreciated..." |
|
|
|
|
|
Locking