title: Problem with DATE type in SQL Server
body: <p>I'm trying to CREATE a TABLE with an attribute of type DATE in Microsoft SQL Server 2008. However, when I execute the query, </p>
  
  <p>I get the error: </p>
  
  <pre><code>Column, parameter, or variable #3: Cannot find data type DATE.
  </code></pre>
  
  <p>I consulted the documentation, and it indicated that DATE is a valid type in SQL Server. It works if I replace "DATE" with "DATETIME". My guess is I'm missing something really simple, but I just started learning SQL and SQL Server; does anybody have an idea?</p>