Common · Knowledge
Transact-SQL
Microsoft's and Sybase's proprietary extension to SQL (Structured Query Language) used to interact with relational databases
Transact-SQL (T-SQL) is an extension of SQL used by Microsoft SQL products and services, including Microsoft SQL Server, and by SAP Adaptive Server Enterprise (SAP ASE). Microsoft states that tools and applications communicating with a SQL Server database do so by sending T-SQL commands.
Read more
SAP describes its implementation as an enhanced version of the relational database language. In January 1988, Microsoft and Ashton-Tate announced Microsoft SQL Server, based on a relational database management system licensed from Sybase. Sybase Adaptive Server Enterprise was later renamed SAP Adaptive Server Enterprise. Microsoft and SAP publish separate Transact-SQL documentation for their respective database systems. The features described in this section refer to Microsoft's implementation of Transact-SQL. Local variables begin with an at sign (@) and are declared using DECLARE. A newly declared variable has the value NULL. Values can be assigned using SET or SELECT, although Microsoft recommends SET for variable assignment.
Text: Wikipédia, CC BY-SA 4.0. ·