| title | Transact-SQL Reference (Database Engine) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 04/03/2017 | ||
| ms.prod | sql-non-specified | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | dbba47d7-e08e-4435-b876-35dced1f325d | ||
| caps.latest.revision | 14 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-all_md]
[!INCLUDEtsql] is central to using [!INCLUDEssNoVersion]. All applications that communicate with an instance of [!INCLUDEssNoVersion] do so by sending [!INCLUDEtsql] statements to the server, regardless of the user interface of the application.
The following is a list of the kinds of applications that can generate [!INCLUDEtsql]:
-
General office productivity applications.
-
Applications that use a graphical user interface (GUI) to let users select the tables and columns from which they want to see data. This includes Microsoft development tools such as SQL Server Management Studio and SQL Server Data Tools.
-
Applications that use general language sentences to determine what data a user wants to see.
-
Line of business applications that store their data in [!INCLUDEssNoVersion] databases. These applications can include both applications written by vendors and applications written in-house.
-
[!INCLUDEtsql] scripts that are run by using utilities such as sqlcmd.
-
Applications created by using development systems such as [!INCLUDEmsCoName] [!INCLUDEvcprvc], [!INCLUDEmsCoName] [!INCLUDEvbprvb], or [!INCLUDEmsCoName] Visual J++ that use database APIs such as ADO, OLE DB, and ODBC.
-
Web pages that extract data from [!INCLUDEssNoVersion] databases.
-
Distributed database systems from which data from [!INCLUDEssNoVersion] is replicated to various databases, or distributed queries are executed.
-
Data warehouses in which data is extracted from online transaction processing (OLTP) systems and summarized for decision-support analysis.
To view the Transact-SQL reference topics
To find [!INCLUDEtsql] 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 [!INCLUDEtsql] key word in the Management Studio Query Editor window, and press F1.
System tables, views, functions, and procedures, are in the Database Features section.
For a short tutorial about how to write [!INCLUDEtsql], see Tutorial: Writing Transact-SQL Statements.
For help with [!INCLUDEtsql] statements, see MSDN Transact-SQL Forum.
The [!INCLUDEtsql] reference includes topics related multiple versions of SQL Server, beginning with [!INCLUDEssKatmai], and related to [!INCLUDEssSDSfull], Azure SQL Data Warehouse, and Parallel Data Warehouse. Near the top of each topic is a section indicating which products support the subject of the topic. For example, this topic applies to all versions, and has the following label.
[!INCLUDEtsql-appliesto-ss2008-all_md]
In some cases, the general subject of topic can be used in a product, but all of the arguments are not supported. For example, contained database users were introduced in [!INCLUDEssSQL11]. The CREATE USER statement can be used in any [!INCLUDEssNoVersion] product, however the WITH PASSWORD syntax cannot be used with older versions. In this case, additional Applies to sections are inserted into the appropriate argument descriptions in the body of the topic.
Transact-SQL Syntax Conventions (Transact-SQL)
SQL Server Database Engine