33-updaterollbacktran.sql

来自「SQL Server 2005基础教程一书的源代码.」· SQL 代码 · 共 18 行

SELECT 'Before',ShareId,ShareDesc,CurrentPrice
  FROM ShareDetails.Shares
-- WHERE ShareId = 3
BEGIN TRAN ShareUpd
UPDATE ShareDetails.Shares
   SET CurrentPrice = CurrentPrice * 1.1
-- WHERE ShareId = 3
SELECT 'Within the transaction',ShareId,ShareDesc,CurrentPrice
  FROM ShareDetails.Shares
ROLLBACK TRAN
SELECT 'After',ShareId,ShareDesc,CurrentPrice
  FROM ShareDetails.Shares
-- WHERE ShareId = 3