SQL Server Performance

row locking

Discussion in 'General DBA Questions' started by ms5, Jan 3, 2007.

  1. ms5 New Member

    Hello all,

    In Oracle in order to lock a row we use:
    select * from emp where empno=1 for update,
    What is a same mechanism in Ms Sql?
    Regards.
  2. alzdba Member

    Begin tran (=implicit with oracle)
    select ... from emp with (UPDLOCK) where empno=1
    ...

  3. satya Moderator

Share This Page