事物回滚

BEGIN TRY
BEGIN TRANSACTION
INSERT INTO Stuinfo VALUES ('aa','22','11')
UPDATE stuinfo SET stu='888' WHERE ID =0
COMMIT TRANSACTION
END TRY
BEGIN CATCH
PRINT '错误'
ROLLBACK TRANSACTION
END CATCH

posted @ 2017-11-19 19:11  嗯哼,还好  阅读(97)  评论(1)    收藏  举报