Answered by:

Auto adding unique primary key field in SQL server 2012

Question

Need to add a column with a a unique primary key. I was just about to upload five hundred thousand record BULK and I trapped on repetition in the field I was going to
use. Need some guidance on this so I can make best choice how to overcome this so that the key field is populated during the bulk load.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.