title: Code required to run a query on the first day of each month
body: <p>I would like to run a query on a MS SQL Server 2014 on the first day of the month, every month.
  Would any of the following be ok?</p>
  
  <pre><code>SELECT *
  FROM Table
  WHERE CONVERT(VARCHAR(2),GETDATE(),104)=1
  </code></pre>
  
  <p>or</p>
  
  <pre><code>SELECT * 
  FROM Table
  WHERE DATEPART(d,GETDATE())=1
  </code></pre>
  
  <p>or</p>
  
  <pre><code>SELECT column_a, MAX(column_b)
  FROM Table
  WHERE column_c=value
  GROUP BY column_a
  HAVING DATEPART(d,GETDATE())=1
  </code></pre>
  
  <p>Tnx</p>