Home Forums SQL Server 7,2000 T-SQL What isolation level and lock type should I use? RE: What isolation level and lock type should I use?

  • May 12, 2005 at 11:02 am

    #558495

    try :

    selec * from tableA with HOLDLOCK

    /*any procesess and others users try to access this tableA but they can't.*/

    Update tableA set field='tutu' where id=1

     

    commit tran

    /*now others users try to access this tableA and they can.*/

     

    salute

    Victor