SQL Commands


SQL Commands


CData Connect supports several operations on data, including querying, deleting, modifying, and inserting.

SELECT Statements

See SELECT Statements for a syntax reference and examples.

INSERT Statements

See INSERT Statements for an example.

UPDATE Statements

The primary key Id is required to update a record. See UPDATE Statements for an example.

UPSERT Statements

An UPSERT statement updates a record if it exists and inserts the record if it does not. See UPSERT Statements for an example.

DELETE Statements

The primary key Id is required to delete a record. See DELETE Statements for a syntax reference and example.

GETDELETED Statements

The GETDELETED query retrieves deleted records. See GETDELETED Statements for an example.

EXECUTE Statements

Use EXECUTE or EXEC statements to execute stored procedures. See EXECUTE Statements for a syntax reference and examples.

INSERT INTO SELECT Statements

An INSERT INTO SELECT statement inserts data from a temporary table. See INSERT INTO SELECT Statements for a syntax reference and examples.

UPDATE SELECT Statements

UPDATE SELECT statements perform multiple updates in a single request. See UPDATE SELECT Statements for a syntax reference and examples.

DELETE SELECT Statements

A DELETE SELECT statement performs multiple deletes in a single request. See DELETE SELECT Statements for a syntax reference and examples.