Sample Header Ad - 728x90

Is this an error in SQL Server's documentation for ROLLBACK?

14 votes
1 answer
1869 views
This is the SQL Server's document talking about the ROLLBACK statement. On that page it states that the syntax of it is as follows: ROLLBACK { TRAN | TRANSACTION } [ transaction_name | @tran_name_variable | savepoint_name | @savepoint_variable ] [ ; ] Apparently the stuff inside square brackets are optional and it seems you should choose one from TRAN or TRASACTION. But in fact you can completely omit both and ROLLBACK is a perfectly valid statement. Is this an error or intentionally?
Asked by Just a learner (2082 rep)
Apr 11, 2021, 08:54 AM
Last activity: Apr 13, 2021, 12:42 PM