title: declare variables in sql ce
body: <p>I am tryin to get records from a table within a month in sql compact edition.
  Here is the sql query I know:</p>
  
  <pre><code>DECLARE @startDate as DATETIME, @EndDate as DATETIME
  
  @startDate = GetDate();
  @ENdDate = DATEADD(m,1,@startDate)
  
  select * from table where (columnname between @startdate and @enddate)
  </code></pre>
  
  <p>I know that you have to send one script at a time, but how can you declare variables in sql ce(I guess it doesn't accept declare)?</p>