title: How do I add a autoincrement primary key in sql server with nvarchar?
body: <p>How make a auto increment primary key with <code>nvarchar</code> datatype in SQL Server 2008 Express? I want my output primary key like:</p>
  
  <pre><code> Id        Name
   A1        AAA
   A2        BBB
  </code></pre>
  
  <p>Thank you</p>