• As Jeff said, not possible.

    I'm curious. Why would you want to do a select with an UPD lock and then immediately commit the transaction? You're not achieving anything as the lock will be dropped as soon as the transaction commits.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass