title: Sql syntax error - expecting ( or as
body: <p>I am trying to write this SQL code:</p>
  
  <pre><code>create table Users
  {
      UserID int primary key identity(200,1),
      FirstName varchar(20) not null,
      LastName varchar(20) not null,
      BirthDate dateTime not null,
      HomeTown varchar(30),
      WorkPlace varchar(40),
      Email not null
  }
  </code></pre>
  
  <p>The problem is that next the <code>{</code> symbol, I get the error: </p>
  
  <blockquote>
    <p>Incorrect syntax near '{'.</p>
  </blockquote>
  
  <p>When my mouse over the sign it adds: </p>
  
  <blockquote>
    <p>Expecting '(' or AS</p>
  </blockquote>
  
  <p>In addition, I also get an error on the values that are in the bracket</p>
  
  <blockquote>
    <p>Incorrect syntax near '20'. Expecting '(' or Select".</p>
  </blockquote>
  
  <p>The thing is that I have another SQL document (that I didn't write) and the same syntax work there! Why is that and how can I solve it?</p>