Report question

Question: How to commit and rollback transaction in sql server?