Microsoft Docs

Transact-SQL Language Reference

This section provides a comprehensive reference for the Transact-SQL (T-SQL) language used by Microsoft SQL Server and Azure SQL Database.

Core Concepts

Transact-SQL is Microsoft's proprietary extension of SQL (Structured Query Language). It supports a rich set of commands and functions for managing and querying data.

• Basic SQL Syntax
• Querying Data (SELECT statements)
• Manipulating Data (INSERT, UPDATE, DELETE)
• Data Definition Language (DDL) Statements (CREATE, ALTER, DROP)
• Data Control Language (DCL) Statements (GRANT, REVOKE)

Key Language Elements

Explore the fundamental building blocks of T-SQL:

• Identifiers
• Literals
• Operators
• Expressions
• Control Flow Language (IF, WHILE, CASE)
• Error Handling (TRY...CATCH)

Common Statements and Constructs

Querying Data

SELECT Column1, Column2
FROM YourTable
WHERE Condition;

Inserting Data

INSERT IntoTable (ColumnA, ColumnB)
VALUES ('Value1', 'Value2');

Updating Data

UPDATE YourTable
SET ColumnToUpdate = 'New Value'
WHERE Condition;

Deleting Data

DELETE FROM YourTable
WHERE Condition;

Creating Tables

CREATE TABLE NewTable (
    ID INT PRIMARY KEY,
    Name VARCHAR(50)
);

Further Resources

• T-SQL Functions Reference
• T-SQL Statements Reference
• System Catalog Views