Summary: be named If the user does not name the transaction SQL Server will do it To note it is possible to write TRAN in the place of TRANSACTION Here an example of transaction management error returns the last error code met If the update request and insertion proceeds successfully error value will be 0 While returning the value of error we will be able to manage
Image Dimensions: 402 x 597
Image originally found here.