Sql Server add auto increment primary key to existing table ...

2011年2月1日 - Sql Server add auto increment primary key to existing table ... a query to fill this column with incremental numbers, and then set as primary key and turn on auto increment. .... Equivalent of MSSQL IDENTITY Column in MySQL.

stackoverflow.com