MSSQL ROLLBACK & COMMIT

MSSQL ROLLBACK & COMMIT


ROLLBACK:

BEGIN TRANSACTION doUpdate
 
--do insert, update, delete
 
ROLLBACK TRANSACTION doUpdate

COMMIT:

BEGIN TRANSACTION doUpdate
 
--do insert, update, delete
 
COMMIT TRANSACTION doUpdate

ref:
https://msdn.microsoft.com/zh-tw/library/ms188929%28v=sql.120%29.aspx
https://msdn.microsoft.com/zh-tw/library/ms190295%28v=sql.120%29.aspx