title: Conditional insert in SqlServer Compact Edition
body: <p>Is there a way to do a conditional insert in the compact edition?
  I've tried two ways that I think would work on SqlServer:</p>
  
  <pre><code>INSERT INTO CUSTQUOTE (QTE_ID) VALUES (1) 
  WHERE EXISTS(SELECT * FROM JOB WHERE JOB_NUMBER = 'EW090800345')
  There was an error parsing the query. [ Token line number = 2,Token line offset = 1,Token in error = WHERE ]
  
  IF EXISTS(SELECT * FROM JOB WHERE JOB_NUMBER = 'EW090800345')
  BEGIN
      INSERT INTO CUSTQUOTE (QTE_ID) VALUES (1)
  END
  There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = IF ]
  </code></pre>