Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases...
6 KB (704 words) - 10:07, 8 June 2023
are also cached as necessary. T-SQL (Transact-SQL) is Microsoft's proprietary procedural language extension for SQL Server. It provides REPL (Read-Eval-Print-Loop)...
61 KB (7,167 words) - 05:20, 24 May 2025
"Visual Expert for Oracle - PL/SQL Code Analyzer". www.visual-expert.com. 2017-08-24. "Visual Expert for SQL Server - Transact SQL Code Analyzer". www.visual-expert...
39 KB (1,197 words) - 07:22, 8 July 2025
(2022-12-16). "Azure SQL Database Transact-SQL differences". Microsoft Azure. danimir. "Compare the database engine features of SQL Database and SQL Managed Instance...
9 KB (787 words) - 09:29, 24 March 2025
Stored procedure (section Comparison with static SQL)
introduction of procedural elements to the SQL language in the SQL:1999 and SQL:2003 standards in the part SQL/PSM. That made SQL an imperative programming language...
12 KB (1,298 words) - 23:08, 5 November 2024
Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), MariaDB includes a PL/SQL compatibility parser, and IBM Db2 includes SQL Procedural...
31 KB (3,904 words) - 07:24, 18 July 2025
"MERGE (Transact-SQL)". Transact-SQL Reference (Database Engine). Microsoft Learn. Archived from the original on Jun 24, 2016. MySQL :: MySQL 5.1 Reference...
10 KB (1,014 words) - 21:05, 31 March 2025
database management systems Query by Example SQL reserved words SQL syntax Oracle PL/SQL Microsoft Transact-SQL (T-SQL) Online transaction processing (OLTP)...
45 KB (4,039 words) - 14:29, 16 July 2025
unique key in database tables. The NEWID function in Microsoft SQL Server version 4 Transact-SQL returns standard random version-4 UUIDs, while the NEWSEQUENTIALID...
38 KB (4,577 words) - 14:19, 1 August 2025
List of unit testing frameworks (section Transact-SQL)
2019-04-30. "tSQLt - Database Unit Testing for SQL Server". Red Gate Software Ltd. "SQL Test - Unit Testing for SQL Server". Red-gate.com. Retrieved 2012-11-12...
188 KB (6,797 words) - 00:28, 2 July 2025
Glob (programming) (section SQL)
Windows Archived 2019-12-24 at the Wayback Machine. MSDN Devblog. "LIKE (Transact-SQL)". 2023-05-23. Archived from the original on 2017-08-02. Retrieved 2017-08-01...
26 KB (2,401 words) - 04:21, 16 July 2025
Development Group. Retrieved 16 April 2025. "Reserved Keywords (Transact-SQL)". Microsoft Docs – SQL Server. Microsoft. Retrieved 23 December 2020. ISO/IEC 9075-2:2023...
113 KB (179 words) - 09:18, 5 August 2025
and sqsh are, essentially, rudimentary command-line tools for issuing Transact-SQL commands to an ASE Server and receiving and displaying results. Sqsh...
2 KB (110 words) - 22:14, 14 January 2025
"Transact-SQL Syntax Conventions". MySQL. "SQL SELECT Syntax". Omitting FROM clause is not standard, but allowed by most major DBMSes. "Transact-SQL Reference"...
33 KB (3,100 words) - 20:59, 25 January 2025
"Oracle Compliance To Core SQL:2003". Docs.oracle.com. Retrieved 7 July 2022. MSDN documentation on UNION in Transact-SQL for SQL Server Naming of select...
8 KB (863 words) - 17:19, 20 July 2023
Procedures (VSP) PostgreSQL PL/pgSQL Proprietary: Oracle PL/SQL Microsoft and Sybase Transact-SQL Invantive Procedural SQL Mimer SQL stored procedures Gulutzan...
7 KB (575 words) - 20:38, 3 June 2023
THEN value3 ... END Some SQL DBMSs implement vendor-specific functions similar to COALESCE. Some systems (e.g. Transact-SQL) implement an ISNULL function...
61 KB (7,610 words) - 11:03, 4 May 2025
Data control language (category SQL)
Transact-SQL (T-SQL), which is an extension of SQL. Similarly, Oracle uses PL-SQL, which an Oracle-specific SQL extension. However, the standard SQL commands...
8 KB (1,011 words) - 16:25, 27 January 2025
Data definition language (redirect from Drop (SQL))
SQL". SQL92. Carnegie Mellon. Retrieved 12 November 2018. Laudenschlager, Douglas; Milener, Gene; Guyer, Craig; Byham, Rick. "Transactions (Transact-SQL)"...
9 KB (1,002 words) - 19:09, 27 November 2024
Tom Toi Topspeed (Clarion) TPU (Text Processing Utility) Trac TTM T-SQL (Transact-SQL) Transcript (LiveCode) TTCN (Tree and Tabular Combined Notation) Turing...
28 KB (1,336 words) - 12:48, 4 July 2025
during this period. Like Oracle's PL/SQL or Microsoft's Transact-SQL, DAL is essentially an extended version of SQL supporting basic query functionality...
5 KB (768 words) - 12:21, 19 April 2025
Standard (IS). Database Language SQL—Part 2: Foundation (SQL/Foundation). 1999. "SELECT - INTO Clause (Transact-SQL)". learn.microsoft.com. 2023-05-23...
35 KB (3,960 words) - 16:09, 15 July 2025
Kline, Kevin; Gould, Lee; Zanevsky, Andrew (1999). Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5. ISBN 9781565924017...
7 KB (900 words) - 13:29, 5 August 2025
Basic C# C/AL a.k.a. Navision Attain F# MVPL Power Fx PowerShell Q# Transact-SQL TypeScript Visual J++ Visual J# Web properties Azure Bing Copilot GitHub...
50 KB (3,417 words) - 23:45, 2 August 2025
Time" from dual; "From clause in Transact SQL". "Reserved Words in SQL". "System Information Schema Views (Transact-SQL)". "Selecting from the DUAL Table"...
3 KB (254 words) - 20:59, 6 February 2023
User-defined function (category SQL)
Multistatement table-valued functions return a table, which was built with many TRANSACT-SQL statements. User-defined functions can be invoked from a query like built‑in...
9 KB (1,257 words) - 11:12, 23 June 2025
Adaptive Server Enterprise (redirect from Sybase SQL Server)
unitext, and image Datatypes in Stored Procedures, Using LOB Locators in Transact-SQL Statements, select for update to exclusively lock rows for subsequent...
13 KB (1,547 words) - 19:04, 6 July 2025
Zhang, Chao (2017). Symmetric and Asymmetric Aggregate Function in Massively Parallel Computing (Technical report). Aggregate Functions (Transact-SQL)...
11 KB (1,472 words) - 20:00, 23 July 2025
Objective-C++, Perl, PHP, Python, Rez, Ruby, Setext, SQL (including Transact-SQL, PL/SQL, MySQL, and PostgreSQL), Tcl, TeX, UNIX shell scripts, XML, and YAML...
16 KB (1,715 words) - 04:25, 29 December 2024
Database transaction (redirect from Begin work (SQL))
Transactions are available in most SQL database implementations, though with varying levels of robustness. For example, MySQL began supporting transactions...
12 KB (1,550 words) - 02:09, 25 May 2025