In one of the projects I’m currently working on, I have to handle multiple SQL operations in one transaction, so if anything goes wrong in a particular operation, things done in previous operations can be rolled back automatically.  This can be done by using Transaction in a Stored Procedure directly, but you might lose some [...]