Upsert an account

Updates or inserts an Account record. This example demonstrates using the UPSERT INTO statement, which checks for existing records based on unique fields before deciding to update or insert.

UPSERT INTO Accounts(Account_Name, Phone) VALUES('Company ABC','111-567-8888') WITH(Output=1)