begin transaction select * from EmployeeInfoTemp WITH (TABLOCK, UPDLOCK) waitfor Delay '00:05:00' commit transaction