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,116 words) - 18:32, 15 November 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
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) - 19:00, 22 October 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,767 words) - 23:13, 9 November 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,197 words) - 17:21, 8 November 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) - 09:17, 21 October 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...
12 KB (1,298 words) - 23:08, 5 November 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,037 words) - 18:03, 25 October 2024
"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
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,599 words) - 15:49, 7 November 2024
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,948 words) - 08:46, 7 November 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
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
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) - 07:25, 28 September 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,510 words) - 07:02, 8 November 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) - 00:53, 1 November 2024
"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) - 23:38, 17 October 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
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
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
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
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,314 words) - 18:19, 12 November 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
Null coalescing operator (section SQL)
In Oracle's PL/SQL, the NVL() function provides the same outcome: NVL(possibly_null_value, 'value if null'); In SQL Server/Transact-SQL there is the ISNULL...
23 KB (2,396 words) - 08:53, 31 October 2024
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) - 23:08, 1 November 2024
Comment (computer programming) (section SQL)
Ddoc for D, Doxygen for C, C++, Java, IDL, Visual Expert for PL/SQL, Transact-SQL, PowerBuilder, and PHPDoc for PHP. Forms of docstring are supported...
55 KB (6,413 words) - 10:25, 28 September 2024
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) - 07:48, 13 November 2024
Varchar (category SQL)
mysql.com. edmacauley (6 June 2024). "char and varchar (Transact-SQL)". msdn.microsoft.com. SQL Server differences of char, nchar, varchar and nvarchar...
2 KB (171 words) - 08:16, 26 July 2024
Development Handbook. CRC Press. ISBN 0-8493-9822-3. CREATE VIEW (Transact-SQL) in SQL Server 2008 Books Online, Microsoft Corporation "Databasekatalog...
2 KB (158 words) - 09:13, 28 September 2024