InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 20:54:48 GMT20http://www.sqlservercentral.com/Forums/Topic1405553-392-1.aspxThe update lock is held until the transaction commits or rolls back.Thu, 10 Jan 2013 11:53:06 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1405553-392-1.aspxHi,Using either HOLDLOCK or UPDLOCK as a lock hint allows other transactions to see the data, but, when used together, the other transactions cannot see the data until the previous transaction is completed.Can anyone shed some light on what happens when these locks are used together, and what happens. Thanks.Thu, 10 Jan 2013 10:32:05 GMTmymail.default