MySQL: BEGIN … END SQL Server: BEGIN … END BEGIN TRAN; COMMIT; OR ROLLBACK; [code lang=”sql”] BEGIN TRAN; UPDATE oi SET oi.TaxForCod = ‘0.08’, oi.TaxAmt = CAST(ROUND((oi.FinAmt / 13.5), 2) AS DECIMAL(18,2)) –SELECT CAST(ROUND((oi.FinAmt / 13.5), 2) AS DECIMAL(18,2)), oi.TotAmt, oi.DisAmt, oi.FinAmt, oi.TaxAmt, oi.TaxForCod, oi.TimCreInDB, * FROM OrdIte oi (NOLOCK) WHERE oi.MaiOrdIteKey IS NULL AND oi.FinAmt != 0.00 AND oi.ordKey IN ( ‘1046030000120211116’, ‘1046030000220211116’ ) COMMIT; OR ROLLBACK; [/code] ]]>