SQL Commands

​

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.