Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Transact-SQL
open-in-new
<p>Transact-SQL (T-SQL) is <a href="/facts/Microsoft/nGIDDXdx">Microsoft</a>'s and <a href="/facts/Sybase/2U3d6RUt">Sybase</a>'s proprietary extension to the <a href="/facts/SQL/UjQLJcYm">SQL</a> (Structured Query Language) used to interact with <a href="/facts/Relational_database/pEKGmJLy">relational databases</a>. T-SQL expands on the SQL standard to include <a href="/facts/Procedural_programming/7r5xz7kx">procedural programming</a>, <a href="/facts/Local_variable/q8sIjyhx">local variables</a>, various support functions for string processing, date processing, mathematics, etc. and changes to the <a href="/facts/Delete_(SQL)/gyapLh6T">DELETE</a> and <a href="/facts/Update_(SQL)/IQz2IKpz">UPDATE</a> statements. </p><p>Transact-SQL is central to using <a href="/facts/Microsoft_SQL_Server/eCdt2JBL">Microsoft SQL Server</a>. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application. </p><p><a href="/facts/Stored_procedure/50xRehaI">Stored procedures</a> in SQL Server are executable server-side routines. The advantage of stored procedures is the ability to pass parameters. </p>