MimerSQL is an SQL based relational database management system from the Sweden Swedish company Mimer Information Technology AB formerly Upright Database Technology AB , which has been developed and produced since the 1970s. The MimerSQL database engine is available for Microsoft Windows , Mac OS X , Linux , Symbian OS , Unix , VxWorks and OpenVMS . Unlike other competing DBMSes, Mimer only implements optimistic concurrency control . ref cite web url http developer.mimer.com features feature 15.htm title Transaction Concurrency Optimistic Concurrency Control work Mimer Developers Features date 26 February 2010 ref References references External links http www.mimer.com Category Proprietary database management systems database software stub pl MimerSQL ... more details
Mimer is The Swedish and Danish name of the Norse god Mimir The name of an iron ore mine in Norberg Municipality , Sweden The database management system called MimerSQL , named after the same god. The RoIP radio dispatch system http www.softradio.se Mimer SoftRadio . disambig sv Mimer olika betydelser ... more details
MimerSQL style text align center SQL PSM SQL Persistent Stored Module implements SQL PSM style text ...About the database language the IATA code San Carlos Airport Infobox programming language name SQL paradigm ... Raymond F. Boyce developer ISO IEC latest release version SQL 2012 latest release date 2012 turing ... management systems Many dialects SQL 86, SQL 89, SQL 92 , SQL 1999 , SQL 2003 , SQL 2008 influenced ... Database languages SQL Part 1 Framework SQL Framework postscript Bot inserted parameter. Either ... file ext .sql Infobox file format name SQL screenshot caption Structured Query Language extension .sql mime application x sql uniform type owner ISO IEC released Start date 1986 df yes latest release version SQL 2008 latest release date Start date and age 2008 df yes genre Database standard ISO IEC ... 45498 title ISO IEC 9075 1 2008 Information technology Database languages SQL Part 1 Framework SQL Framework postscript Bot inserted parameter. Either remove it or change its value to . for the cite to end in a . , as necessary. inconsistent citations ref SQL officially IPAc en icon s k ju l , often IPAc en icon s i k w l ref cite book last Beaulieu first Alan title Learning SQL ..., and data access control. SQL was one of the first commercial languages for Edgar F. Codd ... language. ref name SQL Fundamentals ref name IBM sql cite web title Structured Query Language SQL publisher International Business Machines url http publib.boulder.ibm.com infocenter db2luw v9 ... 10 ref Although SQL is often described as, and to a great extent is, a Declarative programming declarative language , it also includes Procedural programming procedural elements. SQL became a Technical ... with added features. However, issues of SQL code portability between major RDBMS products still exist ... in . History SQL was initially developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early ... chamberlin sequel 1974.pdf accessdate 2007 06 09 ref The acronym SEQUEL was later changed to SQL ... more details
A PREPARE statement in SQL prepares a statement database statement for execute sql execution at a later time. SQL DEFAULTSORT Prepare Sql Category SQL keywords Compu lang stub ... more details
SQL 2008 can refer to SQL 2008 , the SQL standard adopted in 2008 SQL Server 2008, a release of Microsoft SQL Server Letter NumberCombDisambig ... more details
SQL Server may refer to Microsoft SQL Server , a relational database server from Microsoft Sybase SQL Server , a relational database server developed by Sybase SQL Server magazine SQL Server magazine , a trade publication and web site owned by Penton Media Any database server that implements the SQL Structured Query Language disambig Category Servers computing cs SQL Server hr SQL Server it SQL Server nl SQL Server ja SQL Server ro SQL Server ru SQL Server uk SQL Server ... more details
SQL Developer may refer to Oracle SQL Developer , a free SQL IDE from Oracle Corporation PL SQL Developer, an IDE for PL SQL development from Allround Automations SOLYP SQL Developer, a generic proprietary database tool written by Jan Borchers disambig ... more details
The SQL MED , or Management of External Data , extension to the SQL standard is defined by ISO IEC 9075 9 2003. SQL MED provides extensions to SQL that define foreign data wrappers and datalink types to allow SQL to manage external data . External data is data that is accessible to, but not managed by, an SQL based DBMS . This standard can be used in the development of federated database system s. See also SQLSQL 2003 References Empty section date July 2010 External links http www.sigmod.org publications sigmod record 0209 jimmelton.pdf view SQL MED A Status Report Category SQL database stub ru SQL MED ... more details
unreferenced date July 2010 The SQL CLI , or Call Level Interface , extension to the SQL standard is defined in ISO IEC 9075 3 2003. This extension defines common interfacing components structures and procedures that can be used to execute SQL statements from applications written in other programming languages. The SQL CLI extension is defined in such a way that SQL statements and SQL CLI procedure calls are treated as separate from the calling application s source code. See also SQLSQL 2003 References Empty section date July 2010 External links Category SQL database stub ru SQL CLI ... more details
Unreferenced date January 2009 The SQL JRT , or SQL Routines and Types for the Java Programming Language , extension to the SQL standard is defined by ISO IEC 9075 13 2003. SQL JRT specifies the ability to invoke static Java programming language Java methods as routines from within SQL applications. It also calls for the ability to use Java classes as SQL structured user defined types. See also SQL 2003 References Empty section date July 2010 External links DEFAULTSORT Sql Jrt Category SQL database stub ru SQL JRT ... more details
The SQL Schemata , or Information and Definition Schemas , part to the SQL standard is defined by ISO IEC 9075 11 2008. SQL Schemata defines the Information Schema and Definition Schema, providing a common set of tools to make SQL database databases and objects self describing. These tools include the SQL object identifier, structure and integrity constraints , security and authorization specifications, features and packages of ISO IEC 9075, support of features provided by SQL based DBMS implementations, SQL based DBMS implementation information and sizing items, and the values supported by the DBMS implementations. ref name ISO IEC 9075 11 2008 Citation title ISO IEC 9075 11 2008 Information and Definition Schemas SQL Schemata pages p. 1 year 2008 ref . SQL Schemata defines a number of features, some of which are mandatory. See also Data Definition Language CREATE, ALTER, DROP... SQL 2003 Introduced SQL Schemata Data dictionary References references External links Category SQL database stub ru SQL Schemata ... more details
Multiple issues unreferenced December 2009 cleanup March 2008 context October 2009 Meta SQL Use with reference to PeopleSoft Meta SQL expands to platform specific SQL substrings, causes another function to be called, or substitutes a value. Meta SQL constructs are used in functions that pass SQL strings, such as the following SQLExec. Scroll buffer functions ScrollSelect and its relatives . PeopleSoft Application Designer dynamic and SQL views. Some Rowset class methods Select, SelectNew, Fill, and so on. . The SQL class. PeopleSoft Application Engine programs. Some Record class methods Insert, Update, and so on. . COBOL functions. Meta SQL Element Types There are three types of meta SQL elements Constructs are a direct substitution of a value, and help to build or modify a SQL statement. Examples include Bind, InsertSelect, and List. Functions perform actions or cause another function to be called. Examples include ClearCursor, Execute, and ExecuteEdits. Meta variables enable substitution of text within SQL statements. Examples include AsOfDate, Comma, and JobInstance. Meta SQL Placement Considerations Not all meta SQL can be used by all programs. Some meta SQL can be used only in Application Engine programs. Other meta SQL can only be used as part of a SQL statement in a SQL or dynamic view. The following table lists available meta SQL elements and where each element can be used. If a meta SQL construct, function, or meta variable is supported in PeopleCode, it is supported in all types of PeopleCode programs that is, in Application Engine PeopleCode programs actions , component interface PeopleCode programs, and so on. Note Even if a meta SQL element is used in PeopleCode, you cannot use meta SQL like a built in function. You can use meta SQL in the SQLExec function, the Select method, the Fill method, and so on. Note Meta SQL is not available in SQR DEFAULTSORT Meta Sql Category SQL ... more details
A code HAVING code clause in SQL specifies that an SQL code Select SQL SELECT code statement should only return rows where aggregate values meet the specified Condition SQL condition s. It was added When date February 2011 to the SQL language because the code Where SQL WHERE code keyword could not be used with aggregate functions. ref cite web url http www.w3schools.com SQLsql having.asp title SQL HAVING Clause publisher w3schools.com quote The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions. ref Examples To return a list of department IDs whose total sales exceeded 1000 on the date of January 1, 2000, along with the sum of their sales on that date source lang sql SELECT DeptID, SUM SaleAmount FROM Sales WHERE SaleDate 01 Jan 2000 GROUP BY DeptID HAVING SUM SaleAmount 1000 source Referring to the sample tables in the Join SQL example, the following query will return the list of departments who have more than 1 employee source lang sql SELECT DepartmentName, COUNT FROM employee,department WHERE employee.DepartmentID department.DepartmentID GROUP BY DepartmentName HAVING COUNT 1 source References Reflist External links http www.databasejournal.com features mysql article.php 3469351 The HAVING and GROUP BY SQL clauses http www.w3schools.com sqlsql functions.asp SQL Aggregate Functions SQL DEFAULTSORT Having Sql Category SQL keywords Category Articles with example SQL code database stub compu lang stub ru Having SQL sq Having SQL uk Having SQL ... more details
Primary sources date November 2009 Notability date November 2009 SQL PL stands for SQL Structured Query Language Procedural Language and was developed by IBM as a set of commands that extend the use of SQL in the IBM DB2 DB2 UDB Version 7 database system. ref http publib.boulder.ibm.com infocenter db2luw v9 index.jsp?topic com.ibm.db2.udb.apdv.sql.doc doc c0011916.htm IBM Info Center ref It provides procedural programming procedural programmability in addition to the querying commands of SQL. It is a subset of the SQL Persistent Stored Modules SQL PSM language standard. References references External links http www.sqlpl guide.com SQL PL Guide for developing Stored Procedures in DB2 DEFAULTSORT Sql Pl Category SQL Category IBM software Prog lang stub ... more details
The SQL OLB , or Object Language Bindings , extension to the SQL standard is defined by ISO IEC 9075 10 2003. SQL OLB defines the syntax and symantics of SQLJ , which is SQL embedded in Java programming language Java . The standard also describes mechanisms to ensure binary portability of SQLJ applications, and specifies various Java packages and their contained classes. See also SQL SQLJ an outdated term for SQL OLB SQL 2003 External links http www.jcc.com sql.htm Short description database stub Category SQL ru SQL OLB ... more details
SQL Insertion may refer to SQL insertion attack Insert SQL , statement in SQL disambig Short pages monitor This long comment was added to the page to prevent it being listed on Special Shortpages. It and the accompanying monitoring template were generated via Template Longcomment. Please do not remove the monitor template without removing the comment as well. ... more details
SQL Plus commonly known as sqlplus is an Oracle database client that can run SQL and PL SQL commands and display their results. SQL Plus is the default, the simplest and the most basic Oracle utility, with a basic ... types SQL Plus understands three categories of text ref name CommandRef cite web url http www.orafaq.com faq sqlplus title SQL Plus at orafaq.com accessdate 2007 11 26 archiveurl http web.archive.org ... SQL statements PL SQL blocks SQL Plus internal commands, for example environment control commands .... An Oracle programmer in the appropriately configured software environment can launch SQL Plus, for example ... code tiger code . SQL Plus then presents a prompt with the default form of pre SQL> pre Interactive use can then start by entering a SQL statement terminated by a semicolon , a PL SQL block, or another ... pre History The first version of SQL Plus was called UFI User Friendly Interface . UFI appeared in Oracle ... name became Advanced UFI . The name Advanced UFI changed to SQL Plus before the release of this Which? date July 2009 version. As of 2012 1 the product continues to bear the name SQL Plus . Usage ... end users who depend on the SQL Plus environment. Oracle shops typically continue to use SQL Plus scripts ... gui fications replacements for SQL Plus include Oracle SQL Plus Worksheet, a component of Oracle Enterprise Manager OEM ref cite web url http docs.cs.cf.ac.uk html 601 node4.html title The SQL ... Oracle s SQL Plus Worksheet is a straight forward, easy to use, graphical user interface for SQL. ref ... is a web based utility similar to the SQL Plus command line utility for executing SQL and PL SQL commands available up to Oracle 10gR2 . ref SQL Worksheet, ref cite web url http www.oracle.com technology products database sql developer files featurelist 1 5.htm nf sql title Oracle SQL Developer 1.5 ... Oracle Corporation location pages language doi archiveurl archivedate quote The SQL Plus commands supported by Oracle SQL Developer SQL Worksheet are listed ... ref a component of Oracle SQL Developer ... more details
About SQL 2008, a revision of the SQL standard background information about the SQL query language SQLSQL 2008 is the sixth revision of the International Organization for Standardization ISO and ANSI standard for the SQL database query language . It was formally adopted in July 2008. ref name sybase08 http iablog.sybase.com paulley 2008 07 sql2008 now an approved iso international standard SQL 2008 ... expand section date February 2011 The SQL 2008 standard is split into several parts, covering the Framework, the Foundation, the SQL CLI Call Level Interface , SQL PSM Persistent Stored Modules , SQL MED Management of External Data , SQL OLB Object Language Bindings , SQL Schemata Information and Definition Schemas , SQL JRT Routines and Types Using Java programming language Java , and various Related Specifications. Additions to the Foundation include enhanced Merge SQL MERGE and DIAGNOSTIC statements, the Truncate SQL TRUNCATE TABLE statement, comma separated WHEN clauses in a CASE expression, INSTEAD OF database trigger s partitioned Join SQL JOIN tables, support for various XQuery .... ref name sybase08 The Related Specifications for XML defines ways in which SQL can be used in conjunction with XML , including importing and storing XML data in an SQL database, manipulating it within the database and publishing both XML and conventional SQL data in XML form. ref name 9075 14 2008 International Organization for Standardization ISO IEC 9075 14 2008 ref Documentation The SQL standard ... 9075 1 2008 Framework SQL Framework http www.iso.org iso iso catalogue catalogue tc catalogue detail.htm?csnumber 38640 ISO IEC 9075 2 2008 Foundation SQL Foundation http www.iso.org iso iso catalogue catalogue tc catalogue detail.htm?csnumber 38641 ISO IEC 9075 3 2008 Call Level Interface SQL CLI ... 2008 Persistent Stored Modules SQL PSM http www.iso.org iso iso catalogue catalogue tc catalogue detail.htm?csnumber 38643 ISO IEC 9075 9 2008 Management of External Data SQL MED http www.iso.org iso ... more details
SQL PSM stands for SQL Structured Query Language Persistent Stored Modules, and was developed by the American National Standards Institute ANSI as an extension to SQL. ref cite web url http www.itl.nist.gov div897 ctg dm sql info.html title Database Language SQL publisher National Institute of Standards and Technology NIST SQL Project accessdate February 17, 2010 ref It was first adopted in 1996, ref cite journal url http www.dbmsmag.com 9701d06.html title The Future of SQL Programming first Joe last Celko authorlink Joe Celko month January year 1997 journal Intelligent Enterprise DBMS Magazine publisher Miller Freeman archiveurl http web.archive.org web 20070927045233 http www.dbmsmag.com 9701d06.html archivedate September 27, 2007 accessdate February 17, 2010 ref and it provides procedural programming procedural programmability in addition to the querying commands of SQL. The SQL PSM extension is defined by International Organization for Standardization ISO International Electrotechnical Commission IEC 9075 4 2003. SQL PSM standardizes procedural extensions for SQL, including flow of control, condition handling, statement condition signals and resignals, cursors and local variables, and assignment of expressions to variables and parameters. In addition, SQL PSM formalizes declaration and maintenance of persistent database language routines e.g. , stored procedures . See also SQLSQL 2003 References reflist External links http www.pgsql.cz index.php SQL PSM Manual Some samples of SQL PSM functions compu lang stub database stub Category Data management Category SQL Category Data centric programming languages Category Programming languages created in the 1990s ru SQL PSM ... more details
The SQL From clause is the source of a rowset to be operated upon in a Data Manipulation Language Data Manipulation Language DML statement. From clauses are very common, and will provide the rowset to be exposed through a Select SQL Select statement, the source of values in an Update SQL Update statement, and the target rows to be deleted in a Delete SQL Delete statement. code FROM code is an SQL reserved word in the SQL 2003 SQL standard The code FROM code clause is used in conjunction with SQL statements, and takes the following general form SQL DML Statement FROM table name WHERE predicate The From clause can generally be anything that returns a rowset, a table, view, function, or system provided information like the Information Schema , which is typically running proprietary commands and returning the information in a table form. ref cite web url http www.sqlteam.com article the from clause title The FROM Clause author Bill Graziano date 24 June 2002 ref Examples The following query returns only those rows from table mytable where the value in column mycol is greater than 100. source lang sql SELECT FROM mytable WHERE mycol 100 source Requirement The From clause is technically required in relational algebra and in most scenarios to be useful. However many relational DBMS implementations may not require it for selecting a single value, or single row. source lang sql SELECT 3.14 AS Pi source Other systems will require a From statement with a keyword, even to select system data. source lang sql select to char sysdate, Dy DD Mon YYYY HH24 MI SS as Current Time from dual source ref cite web url http infolab.stanford.edu ullman fcdb oracle or time.html title Oracle Dates and Times ref References reflist SQL DEFAULTSORT From Sql Category SQL keywords Category Articles with example SQL code database stub sq From SQL uk From SQL ... more details
dablink This article is about SQL 2003 , a revision of the SQL standard. For more information about SQL, see the main SQL article. SQL 2003 is the fifth revision of the SQL database query language . The latest revision of the standard is SQL 2008 . Summary The SQL 2003 standard makes minor modifications to all parts of SQL 1999 also known as SQL3 , and officially introduces a few new features such as ref ... first Andrew coauthors et al. title SQL 2003 Has Been Published format pdf journal SIGMOD Record ... standards Bot retrieved archive archivedate 2007 11 11 ref XML related features SQL XML Window function SQL Window functions the sequence generator, which allows standardized sequences two new column types auto generated values and identity columns the new Merge SQL MERGE statement extensions to the Data ... removal of the poorly implemented BIT and BIT VARYING data types Documentation availability The SQL standard is not freely available. SQL 2003 may be purchased from http www.iso.org ISO or http webstore.ansi.org ANSI . A late draft is available as a http www.wiscorp.com sql 2003 standard.zip zip archive ... a number of Portable Document Format PDF files that define the parts of the SQL 2003 specification ... 2003 &ndash Framework SQL Framework http www.iso.org iso en CatalogueDetailPage.CatalogueDetail?CSNUMBER 34133 ISO IEC 9075 2 2003 &ndash Foundation SQL Foundation http www.iso.org iso en CatalogueDetailPage.CatalogueDetail?CSNUMBER 34134 ISO IEC 9075 3 2003 &ndash Call Level Interface SQL CLI http ... Stored Modules SQL PSM http www.iso.org iso en CatalogueDetailPage.CatalogueDetail?CSNUMBER 34136 ISO IEC 9075 9 2003 &ndash Management of External Data SQL MED http www.iso.org iso en CatalogueDetailPage.CatalogueDetail?CSNUMBER 34137 ISO IEC 9075 10 2003 &ndash Object Language Bindings SQL ... &ndash Information and Definition Schemas SQL Schemata http www.iso.org iso en CatalogueDetailPage.CatalogueDetail?CSNUMBER 37102 ISO IEC 9075 13 2003 &ndash SQL Routines and Types Using the Java programming ... more details
SQL Azure formerly SQL Server Data Services and later SQL Services is a cloud computing cloud based software as a service service from Microsoft offering data storage capabilities similar to those of Amazon S3 and Amazon Relational Database Service as a part of the Azure Services Platform . Unlike similar cloud based databases, SQL Azure allows users to make relational database relational queries against stored data, which can either be structured data structured or semi structured data semi structured ... azure faq.mspx sql title Microsoft SQL Services FAQ publisher Microsoft accessdate 2009 04 16 ref SQL Azure features querying data, search, data analysis and data synchronization. ref name faq SQL Azure uses a special version of Microsoft SQL Server as its backend. It provides high availability ... of the full SQL Server functionality, including only a subset of the data types &mdash including ... 03 06 sql server data services.aspx title SQL Server Data Services publisher MSDN Blogs author Ryan ... Microsoft SQL Server , SQL Azure uses T SQL as the query language and Tabular Data Stream TDS as the protocol ... azure data.mspx title SQL Server Data Services publisher Microsoft accessdate 2009 04 16 ref The product ... Database Master Database Management Tool for SQL Azure References reflist cite book last Krishnaswamy first Jayaram title Microsoft SQL Azure Enterprise Application Development year 2010 publisher Packt ... SQL Azure Windows Azure Platform http blogs.msdn.com ssds default.aspx SQL Azure Team blog http www.microsoft.com en us SQLAzure datasync.aspx SQL Azure Data Sync http channel9.msdn.com learn courses Azure SQLAzure SQL Azure Online Training course http blog.sqlauthority.com 2009 11 29 sql server azure start guide step by step installation guide SQL Azure Step by Step Installation Guide Microsoft Azure Services Platform Cloud computing Microsoft Microsoft development tools DEFAULTSORT Sql Azure Category Microsoft cloud services ar ja SQL Azure ru SQL Azure zh SQL Azure ... more details
Refimprove date December 2009 A relational database management system uses SQL conditions or Expression programming expressions in Where SQL tt WHERE tt clauses and in Having SQL tt HAVING tt clauses to tt select SQL SELECT tt subsets of data. Types of condition Expand section date July 2010 Many conditions compare values for for example equality, inequality or similarity. The EXISTS condition uses the SQL 2003 SQL standard SQL keywords keyword code EXISTS code ref cite book last Fehily first Chris title SQL Visual Quickstart Guide edition 2 year 2005 publisher Peachpit Press isbn 978 0 321 33417 6 pages 439 440 pages 480 quote SQL Keywords ... The appendix lists the SQL 2003 standard s reserved and non reserved keywords. ... EXISTS ... ref to determine whether rows exist in a subquery result. ref cite book last Fehily first Chris title SQL Visual Quickstart Guide edition 2 year 2005 publisher Peachpit Press isbn 978 0 321 33417 6 page 278 pages 480 quote EXISTS and NOT EXISTS ... look for the existence or nonexistence of rows in a subquery result. ref Examples To tt SELECT tt one row of data from a table called tab with a primary key column pk set to 100 &mdash use the condition pk 100 SELECT FROM tab WHERE pk 100 To identify whether a table tab has rows of data with a duplicated key column dk set to 100 &mdash use the condition dk 100 and the condition having count 1 SELECT FROM tab WHERE dk 100 having count 1 SQL References Reflist DEFAULTSORT Condition Sql Category SQL ru SQL ... more details
Transact SQL T SQL is Microsoft s and Sybase s proprietary extension to SQL . SQL, often expanded to Structured Query Language, is a SQL Standardization standardized computer language that was originally ... declarative statements. T SQL expands on the SQL standard to include Procedural programming ..., mathematics, etc. and changes to the Delete SQL DELETE and update SQL UPDATE statements. These additional features make Transact SQL Turing complete . Transact SQL is central to using Microsoft SQL Server . 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. Flow control Keywords for flow control in Transact SQL include code BEGIN code and code END code , code BREAK code ... SQL, both the DELETE and UPDATE statements allow a FROM clause to be added, which allows joins ... f.name Idle syntaxhighlight BULK INSERT BULK INSERT is a Transact SQL statement that implements ... en us library ms188365.aspx Microsoft s MSDN page . TRY CATCH Beginning with SQL Server 2005, Microsoft ... enables developers to simplify their code and leave out ERROR checking after each SQL execution statement ... See also Adaptive Server Enterprise Adaptive Server Enterprise Sybase PL SQL PL SQL Oracle PL pgSQL ... 15.0.sqlug html sqlug title.htm Sybase Transact SQL User s Guide http msdn2.microsoft.com en us library aa260642 SQL.80 .aspx Transact SQL Reference for SQL Server 2000 MSDN http msdn2.microsoft.com en us library ms189826.aspx Transact SQL Reference for SQL Server 2005 MSDN http msdn.microsoft.com en us library bb510741 SQL.100 .aspx Transact SQL Reference for SQL Server 2008 MSDN Category SQL Category Data centric programming languages ar cs Transact SQL de Transact SQL es Transact SQL fr Transact SQL id Transact SQL is Transact SQL it Transact SQL ja Transact SQL pl Transact SQL pt Transact SQL ru Transact SQL ta zh Transact SQL ... more details
Encyclopedia
top
