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 |
|
sguerra
Starting Member
3 Posts |
 Posted - 2005-09-23 : 19:38:40
|
| I need to know how does sql server locks the rows of a select.With a statement like this:**************************************BEGIN TRANselect max(numero_reg)from cont_registro with (holdlock,rowlock) where serial_dia = 15//// do my stuffCOMMIT TRAN**************************************Is sql server locking all the rows of the where clause "where serial_dia = 15"ORIs sql server locking ONLY one row that complies whit"max(numero_reg)" and has "serial_dia = 15"Please helpSantiago G. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Rowlocking in SQL server