Basic usage of SQL Server transaction processing

SQL Server @ @ERROR test each of the errors of the statement.

Correct time @ @ERROR = = 0 Otherwise the error code is returned.

(1)@ @ERROR function ==0 There is no error, otherwise an error code is returned.

(2) BEGIN TRANSACTION XXX; -- start a transaction

ROLLBACK TRANSACTION XXX; -- rolling back a transaction

COMMIT TRANSACTION XXX; -- Commit a transaction

This article is from the "Spring Stone High" blog, please be sure to keep this source http://mailforchina.blog.51cto.com/2196440/1773247

Basic usage of SQL Server transaction processing