Database transactions can be committed and rolled back using front end tools like .Net or java. Here is a simple code to do so in c#.net

private void SQLCommandTransaction(string sServer, string sDB)
{
SqlConnection cn = new SqlConnection(“SERVER=” + sServer
+ “;INTEGRATED SECURITY=True;DATABASE=” + sDB);
SqlCommand cmd = new SqlCommand();
SqlTransaction trans;
// Start a local transaction
cn.Open();
trans = cn.BeginTransaction();
cmd.Connection = cn;
cmd.Transaction = trans;
try
{
// Insert a row transaction
cmd.CommandText =
“INSERT INTO Department VALUES(100, ‘Transaction 100′)”;
cmd.ExecuteNonQuery();
// This will result in an error
cmd.CommandText =
“INSERT INTO Department VALUES(100, ‘Transaction 101′)”;
cmd.ExecuteNonQuery();
trans.Commit();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
trans.Rollback();
}
finally
{
cn.Close();
}
}