title

description

author

ms.author

ms.reviewer

ms.date

ms.service

ms.subservice

ms.topic

ms.custom

f1_keywords

helpviewer_keywords

monikerRange

Transact-SQL Reference (Database Engine)

This article gives the basics about how to find and use Transact-SQL (T-SQL) reference articles.

MikeRayMSFT

mikeray

randolphwest

12/27/2024

sql

t-sql

reference

ignite-2024

sql13.tsqlref.f1

devlang-tsql

Transact-SQL

>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric

Transact-SQL reference (Database Engine)

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb]

This article gives the basics about how to find and use the Microsoft [!INCLUDE tsql] (T-SQL) reference articles. T-SQL is central to using Microsoft SQL products and services. All tools and applications that communicate with a SQL Server database do so by sending T-SQL commands.

T-SQL compliance with the SQL standard

For detailed technical documents about how certain standards are implemented in [!INCLUDE ssNoVersion], see the Microsoft SQL Server Standards Support documentation.

Tools that use T-SQL

Some of the Microsoft tools that issue T-SQL commands are:

SQL Server Management Studio (SSMS)
Azure Data Studio
SQL Server Data Tools (SSDT)
sqlcmd

Locate the Transact-SQL reference articles

To find T-SQL articles, use search at the top right of this page, or use the table of contents on the left side of the page. You can also type a T-SQL key word in the Management Studio Query Editor window, and press F1.

Common Transact-SQL statements

SELECT
INSERT
UPDATE
DELETE

For more information, see Transact-SQL statements.

Find system views

To find the system tables, views, functions, and procedures, see these links, which are in the Databases section of the SQL documentation.

System catalog views
System compatibility views
System dynamic management views
System functions by category
System information schema views
System stored procedures
System tables

"Applies to" references

The T-SQL reference articles encompass multiple versions of SQL Server, starting with [!INCLUDE sql2008-md], and the other Azure SQL services. Near the top of each article, is a section that indicates which products and services support subject of the article.

For example, this article applies to all versions, and has the following label.

[!INCLUDE sql-asdb-asa-pdw]

Another example, the following label indicates an article that applies only to Azure Synapse Analytics and Parallel Data Warehouse.

[!INCLUDE asa-pdw]

In some cases, the article is used by a product or service, but all of the arguments aren't supported. In this case, other Applies to sections are inserted into the appropriate argument descriptions in the body of the article.

For more information, see SQL Server docs navigation guide.

Get help from Microsoft Q & A

For online help, see the Microsoft Q & A Transact-SQL Forum.

See other language references

The SQL docs include these other language references:

XQuery language reference (SQL Server)
Integration Services language reference
Replication language reference
Multidimensional Expressions (MDX) reference

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!