What is T-SQL (Transact-SQL)?

Transact-SQL is proprietary extension SQL from Sybase and Microsoft that add several features to the Structured Query Language (SQL) including transaction control, exception and error handling, row processing, and declared variables. Microsoft's SQL Server and Sybase's SQL server support T-SQL statements. All applications that communicate with SQL Server do so by sending Transact-SQL statements to the server, regardless of an application's user interface. Microsoft's implementation ships in the Microsoft SQL Server product. Sybase uses the language in its Adaptive Server Enterprise, the successor to Sybase SQL Server.

Transact-SQL is generated from many kinds of applications, including:

General office productivity applications.

Applications that use a graphical user interface (GUI) to allow users to select the tables and columns from which they want to see data.

Applications that use general language sentences to determine what data a user wants to see.

Line of business applications that store their data in SQL Server databases. These can include both applications from other vendors and applications written in-house.

Transact-SQL scripts that are run by using utilities such as OSQL.

Applications created with development systems such as Microsoft Visual C++, Microsoft Visual Basic, or Microsoft Visual J++ that use database application programming interfaces (APIs) such as ADO, OLE DB, and ODBC.

Web pages that extract data from SQL Server databases.

Distributed database systems from which data from SQL Server 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.

Readers also visit these:

Related Questions: