title: SQL Server - Create auto-incrementing unique key
body: <p>Is there a way in SQL Server to create a table with a primary key that auto-increments itself?  I've been looking at the "UniqueIdentifier" type, but this doesn't seem to do what I expect.</p>
  
  <p>Currently, I have something like this:</p>
  
  <pre><code>CREATE TABLE [dbo].[MyTable](
          [Date] [datetime] NOT NULL,
      [MyField1] [nchar](50) NOT NULL,
      [MyField2] [nvarchar](max) NULL,
      [Key] [uniqueidentifier] NOT NULL
  ) ON [PRIMARY]
  </code></pre>
  
  <p>Basically, I want KEY to start at 1 and just increment itself for each record.</p>