Create a customer
Creates a new customer record in the Customers table. This example demonstrates how to use the INSERT INTO statement to specify customer details such as name, email, phone, and address information.
INSERT INTO Customers
([Name]
, [Email]
, [Description]
, [Phone]
, [Balance]
, [AddressLine1]
, [AddressLine2]
, [AddressCity]
, [AddressState]
, [AddressCountry]
, [AddressPostalCode]
, [InvoicePrefix]
)
VALUES('Cust-1'
, 'email@abc.com'
, 'Some desc'
, '+1 222-333-4444'
, 0
, '55 Main St.'
, 'Suite 100'
, 'New York'
, 'NY'
, 'USA'
, '07204' --JSON fragment
, 'INVC'
)