title: Can a sql server table have two identity columns?
body: <p>I need to have one column as the primary key and another to auto increment an order number field. Is this possible?</p>
  
  <p>EDIT: I think I'll just use a composite number as the order number. Thanks anyways.</p>