数据库事务实例

CREATE TABLE bank
(
customerName CHAR(10), --顾客姓名
currentMoney MONEY --当前余额
)
GO
ALTER TABLE bank
ADD CONSTRAINT CK_currentMoney
CHECK(currentMoney >= 1)
GO
INSERT INTO bank(customerName, currentMoney)
VALUES('张三', 1000)
INSERT INTO bank(customerName, currentMoney)
VALUES('李四', 1)

/*--转账测试：张三转账1000元给李四--*/
--我们可能会这样编写语句
--张三的账户少1000元，李四的账户多1000元
UPDATE bank SET currentMoney = currentMoney - 1000
WHERE customerName = '张三'
UPDATE bank SET currentMoney = currentMoney + 1000
WHERE customerName = '李四'
GO
--再次查看转账后的结果
SELECT * FROM bank
GO