December 23, 2010 at 2:26 pm
I have Transaction,which includes a lots of Updates and Inserts.If I use RowLock hint with my Update statements,will this lock remain until the end of the transaction or it will be freed after the end of Update statement?and what is the use of UPLDLock?
December 23, 2010 at 6:16 pm
You don't need to use locking hints. The locks will be held until the transaction is committed or rolled back.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);December 24, 2010 at 2:50 am
Second that,
Let SQL server handle the locks and do not give a hint.
Also, SQL will upgrade locks to page locks/ table locks if needed - you do not have to worry about it.
THe locks will be for the entire transaction - until a rollback or commit. (If you have nested transaction - then only the last commit will commit the transaction and free the locks)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply