How should you complete the relevant Transact-SQL script?

You are developing a SQL Server database for an order management system. The database contains a table that is defined by the following Transact-SQL statement:

Transactions must commit if there are no errors. Transactions must roll back if constraint violations occur.
You need to create the Transact-SQL script to insert new orders.
How should you complete the relevant Transact-SQL script? To answer, select the appropriate Transact-SQL statements from each list in the answer area.
Hot Area:

Correct Answer:

Explanation/Reference:
Box 1: SET XACT_ABORT ON;
XACT_ABORT specifies whether SQL Server automatically rolls back the current transaction when a Transact-SQL statement raises a run-time error.
When SET XACT_ABORT is ON, if a Transact-SQL statement raises arun-time error, the entire transaction is terminated and rolled back.
Box 2: IF (XACT_STATE()) =-1
If XACT_STATE has the value of -1, then the current request has an active user transaction, but an error has occurred that has caused the transaction to declassified as an uncommittable transaction. The request cannot commit the transaction or roll back to a savepoint; it can only request a full rollback of the transaction.
Box 3: IF (XACT.STATEO) =1
If XACT_STATE has the value of 1, then the current request has an active user transaction. The request can perform any actions, including writing data and committing the transaction.
References:
https://msdn.microsoft.com/en-us/library/msl88792.aspx
https://msdn.microsoft.com/en-us/library/msl89797.aspx