title: SQL Server: most commonly used data types?
body: <p>I'm a bit confused as there are many variable types in sql server (ntext, varchar, nvarchar, etc) so maybe if you give me what data types you use for the following fields I'll understand this a little better. If I'm missing a common field type please let me know.</p>
  
  <p>ID<br/>
  Telephone Number<br/>
  Email<br/>
  Description (a paragraph of text)<br/>
  Name<br/>
  SSN<br/>
  Price<br/>
  Ship Date<br/>
  Sex (m/f)<br/>
  Discontinued (yes/no)<br/>
  Quantity<br/>
  Zip Code<br/></p>