Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Skip to content
Permalink
live
Switch branches/tags
Go to file
 
 
Cannot retrieve contributors at this time
title description ms.custom ms.date ms.prod ms.technology ms.topic f1_keywords helpviewer_keywords author ms.author ms.reviewer monikerRange
Transact-SQL Reference (Database Engine)
Transact-SQL Reference (Database Engine)
04/29/2020
sql
t-sql
reference
sql13.tsqlref.f1
devlang-tsql
Transact-SQL
MikeRayMSFT
mikeray
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

Transact-SQL Reference (Database Engine)

[!INCLUDE sql-asdb-asdbmi-asa-pdw]

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

T-SQL compliance with SQL Standard

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

Tools that use T-SQL

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

Locate the Transact-SQL reference topics

To find T-SQL topics, 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.

Find system views

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

"Applies to" references

The T-SQL reference topics encompass multiple versions of SQL Server, starting with 2008, and the other Azure SQL services. Near the top of each topic is a section that indicates which products and services support subject of the topic.

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

[!INCLUDEtsql-appliesto-ss2008-all_md]

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

[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-pdw_md]

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

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:

Next steps

Now that you understand how to find the T-SQL reference topics, you're ready to: