title: How to save 0 as the first number in SQL
body: <p>I have a table which stores only 6 digit numbers and there are numbers which contain 0 as there first letter even there are numbers which contain more than one 0's as there first letters..</p>
  
  <pre><code>          using (TransactionScope scope = new TransactionScope())
              {
  
                  using (SqlConnection conn = new SqlConnection(constr))
                  {
                      conn.Open();
                      using (SqlCommand cmd = new SqlCommand(query, conn))
                      {
                          cmd.Parameters.Add(new SqlParameter("@numType", numTyp));
                          cmd.Parameters.Add(new SqlParameter("@numFrom", textBox1.Text));
                          cmd.Parameters.Add(new SqlParameter("@numTo", textBox2.Text));
                          cmd.ExecuteNonQuery();
                      }
                      conn.Close();
                  }
  
                  scope.Complete();
  </code></pre>
  
  <p>data is being saved and also retrieving but if the first numbers are 0's then sql omits them,, they are important... for eg a number 001234 is saved as 1234 in db .. so how can i fix this i searched but no luck ..</p>
  
  <p>using Sqlserver 2008 visualstudio 2010 c# </p>
  
  <p>hope it is not vague,, Thanks in Advance</p>
  
  <p><strong>EDIT: I am using int as a data type</strong></p>