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 - 2004-05-05 : 14:51:00
|
| Alessandro writes "I'm a developer in VB, and I'm making query on a table on SQL server 2000 using Transaction.When I Make an update query on a table, this table will be unavable for the other software.I was thinking that a query under transaction was able to update the table on database without to lock this table.May you help me.ThanksAlessandro" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-05 : 14:57:27
|
| A transaction will cause the locks to be held until the end of the transaction when the data will becaome viewable by other connections.You should always make transactions as short as possible,Explicit transactions are not necessary for single sql statementsThey do not cause locks to be held for sleects without a lock hint.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Transaction