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,107 words) - 21:26, 20 August 2024
(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) - 19:41, 8 July 2024
database management systems Query by Example SQL reserved words SQL syntax Oracle PL/SQL Microsoft Transact-SQL (T-SQL) Online transaction processing (OLTP)...
40 KB (3,765 words) - 07:06, 2 September 2024
"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...
38 KB (1,193 words) - 23:06, 27 July 2024
THEN value3 ... END Some SQL DBMSs implement vendor-specific functions similar to COALESCE. Some systems (e.g. Transact-SQL) implement an ISNULL function...
62 KB (7,601 words) - 02:41, 24 July 2024
Development Group. Retrieved 31 October 2022. "Reserved Keywords (Transact-SQL)". Microsoft Docs – SQL Server. Microsoft. Retrieved 23 December 2020. ISO/IEC 9075-2:2023...
113 KB (159 words) - 11:04, 3 January 2024
"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,013 words) - 05:58, 5 September 2024
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...
11 KB (1,298 words) - 03:56, 9 June 2024
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...
37 KB (4,491 words) - 19:55, 3 September 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) - 12:19, 7 August 2024
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...
186 KB (6,720 words) - 19:38, 5 September 2024
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...
23 KB (2,034 words) - 20:19, 7 June 2024
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
"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,102 words) - 00:52, 12 June 2024
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) - 20:13, 15 March 2024
into Java. Language binding Module SQL PL/SQL Pro*C/C++ SQL/OLB SQL PL Transact-SQL "The Module Language Concept". SQL*Module for Ada Programmer's Guide...
9 KB (907 words) - 04:22, 5 December 2023
"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
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) - 10:58, 14 December 2023
application was originally conceived by Thierry D'Hers and Amir Netz of the SQL Server Reporting Services team at Microsoft. It was originally designed by...
15 KB (1,751 words) - 05:01, 5 September 2024
Data control language (category SQL)
Example Microsoft SQL server uses Transact-SQL (T-SQL) which is an extension of SQL. Similarly Oracle uses PL-SQL which is their proprietary extension...
8 KB (981 words) - 08:45, 11 September 2023
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) - 14:53, 13 May 2024
(IS). Database Language SQL—Part 2: Foundation (SQL/Foundation). 1999. "Transact-SQL Reference". SQL Server Language Reference. SQL Server 2005 Books Online...
35 KB (3,945 words) - 19:43, 6 August 2024
Visual Basic C# C/AL a.k.a Navision Attain F# MVPL Power Fx PowerShell Transact-SQL TypeScript Q# Visual J# Visual J++ Web properties Azure Bing Copilot...
10 KB (772 words) - 05:05, 31 May 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,311 words) - 16:52, 24 August 2024
Aggregate function "SQL GROUP BY Statement". www.w3schools.com. Retrieved 2020-09-18. shkale-msft. "GROUP BY (Transact-SQL) - SQL Server". docs.microsoft...
3 KB (303 words) - 17:53, 7 November 2023
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) - 19:56, 15 January 2024
36 Relational database management system Component-oriented database Transact-SQL Database management system Bennett, Mathew (2002). Programming Oracle...
10 KB (1,083 words) - 21:13, 20 March 2022
Systems Development Handbook. CRC Press. ISBN 0-8493-9822-3. CREATE VIEW (Transact-SQL) in SQL Server 2008 Books Online, Microsoft Corporation v t e...
1 KB (107 words) - 15:01, 23 January 2022
Visual Basic C# C/AL a.k.a Navision Attain F# MVPL Power Fx PowerShell Transact-SQL TypeScript Q# Visual J# Visual J++ Web properties Azure Bing Copilot...
19 KB (1,420 words) - 16:57, 5 July 2024