| title | Transact-SQL Reference (Database Engine) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 04/03/2017 | ||
| ms.prod | sql | ||
| ms.reviewer | |||
| ms.technology | t-sql | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | dbba47d7-e08e-4435-b876-35dced1f325d | ||
| author | MikeRayMSFT | ||
| ms.author | mikeray | ||
| manager | craigg | ||
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEtsql-appliesto-ss2008-all-md]
This topic gives the basics about how to find and use the Microsoft Transact-SQL (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.
Some of the Microsoft tools that issue T-SQL commands are:
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.
To find the system tables, views, functions, and procedures, see these links which are in the Using relational databases section of the SQL documentation.
- System catalog Views
- System compatibility views
- System dynamic management views
- System functions
- System information schema views
- System stored procedures
- System tables
The T-SQL reference topics encompass multiple versions of SQL Server, starting with 2008, as well as 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 SQL Data Warehouse 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, additional Applies to sections are inserted into the appropriate argument descriptions in the body of the topic.
For online help, see the MSDN Transact-SQL Forum.
The SQL docs include these other language references:
- XQuery Language Reference
- Integration Services Language Reference
- Replication Language Reference
- Analysis Services Language Reference
Now that you understand how to find the T-SQL reference topics, you are ready to:
- Work through a short tutorial about how to write T-SQL, see Tutorial: Writing Transact-SQL Statements.
- View the Transact-SQL Syntax Conventions (Transact-SQL).