BEGIN TRANSACTION; WITH T AS (SELECT * FROM T_UPD WITH (NOLOCK)) UPDATE T_UPD SET VAL = LOWER(VAL) WHERE ID IN (SELECT ID FROM T_UPD); WAITFOR DELAY '00:00:30' COMMIT;