关于事务处理
USE pubs
BEGIN TRAN
SELECT COUNT(*) AS CountBefore FROM sales
TRUNCATE TABLE sales
SELECT COUNT(*) AS CountAfter FROM sales
GO
ROLLBACK TRAN
SELECT COUNT(*) AS CountAfterRollback FROM sales
结果如下:
CountBefore
------------
25
CountAfter
-----------
0
CountAfterback
-----------------
25
事务处理不是包含在BEGIN和COMMIT之间的吗,其中任何一条语句没执行就回滚,也可以根据条件用ROLLBACK强制回滚,上面的是怎么回事,另外程序中TRUNCATE TABLE sales是什么意思,第二个查询为什么是0