title: Insert data into two table in SQL
body: <p>It it possible to insert data into two table simultaneously? In my current page, there is only one command that insert data only in one table,CarTab.</p>
  
  <pre><code> SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ConnectionString);
      SqlCommand cmd = new SqlCommand("Insert into CarTab(Manufacture,Model,Plate,Color,Year,Service,Roadtax) Values (@manufactures,@models,@plates,@colors,@years,@services,@roadtaxs)", conn);
  
      cmd.CommandType = CommandType.Text;
      cmd.Parameters.AddWithValue("@manufactures", Label1.Text);
      cmd.Parameters.AddWithValue("@models", Label2.Text);
      cmd.Parameters.AddWithValue("@plates", Label3.Text);
      cmd.Parameters.AddWithValue("@colors", Label4.Text);
      cmd.Parameters.AddWithValue("@years", Label5.Text);
      cmd.Parameters.AddWithValue("@services", Label6.Text);
      cmd.Parameters.AddWithValue("@roadtaxs", Label7.Text);
  
  
      conn.Open();
      cmd.ExecuteNonQuery();
  </code></pre>
  
  <p>If I want to put another table, TempTab what is the command? Thanks.</p>