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

适用对象: yesSQL ServeryesAzure SQL 数据库yesAzure SQL 数据仓库yes并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

本主题简单介绍关于查找和使用 Microsoft Transact-SQL (T-SQL) 的参考主题。This topic gives the basics about how to find and use the Microsoft Transact-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 的工具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.

适用对象: yesSQL ServeryesAzure SQL 数据库yesAzure SQL 数据仓库yes并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

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

适用对象: noSQL ServernoAzure SQL 数据库yesAzure SQL 数据仓库yes并行数据仓库APPLIES TO: noSQL Server noAzure SQL Database yesAzure SQL Data Warehouse yesParallel 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.

通过 MSDN 论坛获得帮助Get help from the MSDN forum

有关联机帮助的信息,请参阅 MSDN Transact-SQL 论坛For online help, see the MSDN 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: