ASP transaction Processing

When a large number of database inserts, modify, delete and other operations, if you want to implement transactions, you can use the following code. Such as:
<%@ TRANSACTION = required%>
On Error Resume Next
strsql1= "INSERT into a (num) VALUES (1)"
Strsql2= "INSERT into a (num) values (' a ')"
' Execute the first SQL statement
' Execute a second SQL statement
' If the transaction is not present, the first SQL statement is committed to the database.
' Another view of the database found that the transaction rollback of the database is actually a corresponding reverse operation. When the insert is executed, a delete operation is performed in the rollback. Can be obtained by watching the change of the primary key ID.
If ERR Then
ObjectContext.SetAbort ' notifies all supporting transaction components to roll back
Else
ObjectContext.SetComplete
End If
Sub OnTransactionAbort
Response.Write "Error"
' Note that if you use some database-related operations, such as file manipulation, file creation, file deletion, etc. You need to add a rollback operation for the file here. Before the file is created, the corresponding deletion file is required here.
End Sub
Sub OnTransactionCommit
Response.Write "Success"
End Sub