this SQL Query seems to work on SQL2000 but can not get it to work on SQLCE?

  • Thread starter Thread starter jayderk
  • Start date Start date
J

jayderk

I put this in the query analyzer and can not get it to work.

IF NOT EXISTS (SELECT customer_id FROM customer WHERE customer_id =
'testid') INSERT INTO customer(customer_id,event_id) VALUES('testid','TEST
EVENT')


NOTE: the insert statement works great on its own..

regards,
Jay
 
Back
Top