Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
SQL database in Microsoft Fabric
This article gives the basics about how to find and use the Microsoft Transact-SQL (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.
For detailed technical documents about how certain standards are implemented in SQL Server, see the Microsoft SQL Server Standards Support documentation.
Some of the Microsoft tools that issue T-SQL commands are:
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.
For more information, see Transact-SQL statements.
To find the system tables, views, functions, and procedures, see these links, which are in the Databases section of the SQL documentation.
The T-SQL reference articles encompass multiple versions of SQL Server, starting with SQL Server 2008 (10.0.x), 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.
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
Another example, the following label indicates an article that applies only to Azure Synapse Analytics and Parallel Data Warehouse.
Applies to:
Azure Synapse Analytics
Analytics Platform System (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.
For online help, see the Microsoft Q & A Transact-SQL Forum.
The SQL docs include these other language references:
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today