Transact-SQL 參考 (資料庫引擎)Transact-SQL Reference (Database Engine)

適用於: 是SQL Server 是Azure SQL Database 是Azure SQL 資料倉儲 是平行處理資料倉儲 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. 對於使用 Microsoft SQL 產品和服務而言,T-SQL 相當重要。T-SQL is central to using Microsoft SQL products and services. 所有與 SQL 資料庫通訊的工具和應用程式都透過傳送 T-SQL 命令與 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 版本 (從 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 Database 是Azure SQL 資料倉儲 是平行處理資料倉儲 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.

適用於: 否SQL Server 否Azure SQL Database 是Azure SQL 資料倉儲 是平行處理資料倉儲 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: