How do I make a table column auto increment??

<i><b>Originally posted by : Blake Patterson (blake@blakespot.com)</b></i><br /><br /> When creating a table, using MySQL, I was able to enter the field description as, say:<br /><br />unid not null auto_increment primary key,<br /> <br /> ...to set an ideal unid field that would necessarily be unique and would take care of incrementing itself. When entering this straight SQL command-line piece into MS SQL server, it does not like "auto_increment" or any variation of it. How do I set this option using MS SQL server?? Thanks.<br /><br /><br /><br />blake@blakespot.com<br />bp

<i><b>Originally posted by : steve</b></i><br />data type int also check the identity column this an auto incrementer<br /><br /><br />------------<br />Blake Patterson at 4/13/2000 10:42:49 AM<br /><br /><br /> When creating a table, using MySQL, I was able to enter the field description as, say:<br /><br />unid not null auto_increment primary key,<br /> <br /> ...to set an ideal unid field that would necessarily be unique and would take care of incrementing itself. When entering this straight SQL command-line piece into MS SQL server, it does not like "auto_increment" or any variation of it. How do I set this option using MS SQL server?? Thanks.<br /><br /><br /><br />blake@blakespot.com<br />bp