Transact-SQL 引用(数据库引擎)Transact-SQL Reference (Database Engine)

适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics (SQL DW) Parallel 数据仓库

本主题提供有关如何查找和使用 Microsoft Transact-SQLTransact-SQL (T-SQL) 的基础知识。This topic gives the basics about how to find and use the Microsoft Transact-SQLTransact-SQL (T-SQL) reference topics. T-SQL 是使用 Microsoft SQL 产品和服务的关键所在。T-SQL is central to using Microsoft SQL products and services. 与 SQL 数据库通信的所有工具和应用程序均通过发送 T-SQL 命令使用这些产品和服务。All tools and applications that communicate with a SQL database do so by sending T-SQL commands.

T-SQL 的 SQL 标准符合性T-SQL compliance to SQL Standard

有关如何在 SQL ServerSQL Server 中实现某些标准的详细技术文档,请参阅 Microsoft SQL Server 标准支持文档For detailed technical documents about how certain standards are implemented in SQL ServerSQL Server, see the Microsoft SQL Server Standards Support documentation.

使用 T-SQL 的工具Tools that use T-SQL

发出 T-SQL 命令的一些 Microsoft 工具如下:Some of the Microsoft tools that issue T-SQL commands are:

查找 Transact-SQL 参考主题Locate the Transact-SQL reference topics

要查找 T-SQL 主题,请使用本页右上角的搜索功能或使用本页左侧的目录。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. 还可以在 Management Studio 查询编辑器窗口中键入 T-SQL 关键字并按 F1。You can also type a T-SQL key word in the Management Studio Query Editor window, and press F1.

查找系统视图Find system views

要查找系统表、视图、函数和过程,请参阅 SQL 文档使用关系数据库部分中的这些链接。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

T-SQL 参考主题涵盖 SQL Server 的多个版本(2008 版及更高版本),还包含其他 Azure SQL 服务。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.

适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics (SQL DW) Parallel 数据仓库

再如,以下标签指示仅适用于 Azure Synapse Analytics 和并行数据仓库的主题。Another example, the following label indicates a topic that applies only to Azure Synapse Analytics and Parallel Data Warehouse.

适用于:Applies to: 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse适用于:Applies to: 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse

在某些情况下,某个产品或服务使用了主题,但并非所有参数都受到支持。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.

从 Microsoft 问答获取帮助Get help from Microsoft Q & A

有关联机帮助的信息,请参阅 Microsoft 问答 Transact-SQL 论坛For online help, see the Microsoft Q & A Transact-SQL Forum.

查看其他语言参考See other language references

SQL 文档包括包括如下其他语言参考:The SQL docs include these other language references:

后续步骤Next steps

现在,你已了解了如何查找 T-SQL 参考主题,可以:Now that you understand how to find the T-SQL reference topics, you are ready to: