SQL Docs

T‑SQL Statements

SQL Server's Transact‑SQL (T‑SQL) language provides a rich set of statements for defining, manipulating, and controlling data. This reference groups the statements by purpose and includes quick links to detailed pages.

Data Manipulation Statements

SELECT – Retrieve rows from one or more tables or views.
INSERT – Add new rows to a table or view.
UPDATE – Modify existing rows.
DELETE – Remove rows.
MERGE – Perform insert, update, or delete in a single statement.

Data Definition Statements

CREATE – Define database objects (tables, views, procedures, etc.).
ALTER – Change the definition of an existing object.
DROP – Remove objects from the database.
TRUNCATE – Delete all rows from a table quickly.

Transaction Control Statements

BEGIN TRANSACTION – Start a transaction.
COMMIT TRANSACTION – Commit the current transaction.
ROLLBACK TRANSACTION – Undo the transaction.
SAVE TRANSACTION – Define a savepoint.

Security Statements

GRANT – Grant permissions.
REVOKE – Remove permissions.
DENY – Deny permissions.

System and Utility Statements

EXECUTE – Run a stored procedure or batch.
PRINT – Send a message to the client.
RAISERROR – Return an error message.
SET – Change session settings.