Create an account (with output)

Creates a new Account record and returns the created record's details. This example uses WITH(Output=1) to display the result of the INSERT operation.

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