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