例1:定义一事务向 Stucou表插入3条记录,并提交完成。 USE XK GO BEGIN TRANSACTION INSERT StuCou( StuNo, COuNo, WillOrder VALUES(0000253,001’,1) INSERT StuCou (StuNo, COuNo, Willorder) VALUES(000000253,”002,2 INSERT StuCou ( StuNo, COuNo, Willorder) VALUES(000000253,003,3) COMMIT TRANSACTION 测试: SELECT* FroM Stu Cou WHERE StuNo=00000025例1：定义一事务向StuCou表插入3条记录，并提交完成。 USE Xk GO BEGIN TRANSACTION INSERT StuCou(StuNo,COuNo,WillOrder) VALUES ('00000025','001',1) INSERT StuCou(StuNo,COuNo,WillOrder) VALUES ('00000025','002',2) INSERT StuCou(StuNo,COuNo,WillOrder) VALUES ('00000025','003',3) COMMIT TRANSACTION 测试：SELECT * FROM StuCou WHERE StuNo='00000025