I am wondering if there is a way to perform SELECT or INSERT if the record does not exist in a single SQL statement without using WITH clauses (i.e. CTEs)?

It would be cleaner to write such SQL in a single statement then use it in a long and complex query.

Thank you!



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.