title: Creating composite primary key in SQL Server
body: <p>How to add composite primary keys in SQL Server 2008?</p>
  
  <p>I have a table as follows.</p>
  
  <pre><code>testRequest (wardNo nchar(5)
              , BHTNo nchar(5)
              , testID nchar(5)
              , reqDateTime datetime);
  </code></pre>
  
  <p>I need <code>wardNo, BHTNo</code> and <code>testID</code> to be a composite primary key.</p>
  
  <p>How can I do this in SQL Server Management Studio?</p>