title: How do I create a table in SQL Server 2005?
body: <p>I want to create a table called <code>quiz_mailing_list</code> in my database in SQL Server 2005.</p>
  
  <p>With Fields:</p>
  
  <pre><code>id              auto-increment primary key
  email           varchar(256)
  optIn           tinyint
  referringEmail  varchar(256)
  </code></pre>
  
  <p>Here is what I tried:</p>
  
  <pre><code>CREATE TABLE quiz_mailing_list(
          id int identity(1,1) primary key,
          email varchar(256),
          optIn bit
          referringEmail varchar(256))
  </code></pre>
  
  <p>I get this error:</p>
  
  <pre><code>System.Data.SqlClient.SqlException: Incorrect syntax near 'referringEmail'
  </code></pre>
  
  <p>How do I create a table in SQL Server 2005?</p>