About the database language the specific Microsoft database server SQL Server the airport with IATA code SQL San Carlos Airport Infobox programming language name SQL paradigm Multi paradigm programming ... release version SQL 2008 latest release date 2008 turing complete No typing Static typing Static ... SQL 86, SQL 89, SQL 92 , SQL 1999 , SQL 2003 , SQL 2008 influenced by Datalog influenced Agena programming ... Database languages SQL Part 1 Framework SQL Framework file ext .sql Infobox file format name SQL screenshot caption Structured Query Language extension .sql mime application x sql uniform type owner IBM released Start date 1986 df yes latest release version SQL 2008 latest release date Start date and age ... SQL Part 1 Framework SQL Framework SQL IPAc en icon s k ju l , often IPAc en s i k w l , ref cite book last Beaulieu first Alan title Learning SQL editor Mary E Treseler publisher ... 1897740.htm contribution More on Relational Algebra versus Calculus date 2005 04 15 quote SQL s code ... to characterise SQL as just idiosyncratic, but then I would, wouldn t I? I m also happy to omit the syncra ..., database schema schema creation and modification, and data access control. SQL was one of the first ... by Codd , it became the most widely used database language. ref name SQL Fundamentals ref name IBM sql cite web title Structured Query Language SQL publisher International Business Machines url http ... date October 27, 2006 accessdate 2007 06 10 ref History SQL was developed at IBM by Donald D. Chamberlin ... SEQUEL was later changed to SQL because SEQUEL was a trademark of the United Kingdom UK based ... was later supplanted in the marketplace by SQL. ref name oppel databases In the late 1970s, Relational ..., and Boyce and developed their own SQL based RDBMS with aspirations of selling it to the United ... available implementation of SQL, Oracle database Oracle V2 Version2 for VAX computers. Oracle V2 ... 2007 After testing SQL at customer test sites to determine the usefulness and practicality of the system ... more details
SQL Server may refer to Any database server that implements the SQL Structured Query Language Microsoft SQL Server , a specific implementation of 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 disambig Category Servers cs SQL Server de 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
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 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
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 SQLSQL 2003 External links http www.jcc.com sql.htm Short description database stub Category SQL ru SQL OLB ... 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
Unreferenced date December 2009 Context date October 2009 Cleanup date March 2008 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 Construct Constructs are a direct substitution of a value, and help to build or modify a SQL statement. Examples include Bind, InsertSelect, and List. Function Functions perform actions or cause another function to be called. Examples include ClearCursor, Execute, and ExecuteEdits. Meta variable. 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. 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 compu soft stub ... more details
Embedded SQL is a method of combining the computing power of a programming language and the database Data Manipulation Language manipulation capabilities of SQL . Embedded SQL statement programming statements are SQL statements written inline with the program source code of the host language. The embedded SQL statements are parsing parsed by an embedded SQL preprocessor and replaced by host language ... by the host compiler . This allows programmers to embed SQL statements in programs written in any ... SQL standards committee defined the embedded SQL standard in two steps a formalism called Module Language was defined, then the embedded SQL standard was derived from Module Language. ref name modulelang ... The Module Language Concept work SQL Module for Ada Programmer s Guide, Release 8.0, Chapter 1. Introduction to SQL Module publisher Oracle Corporation accessdate 2008 07 14 ref The SQL standard defines embedding of SQL as embedded SQL and the language in which SQL queries are embedded is referred to as the host language . A popular host language is C. The mixed C and embedded SQL is called Pro ... system this precompiler is called ECPG . Other embedded SQL precompilers are Pro Ada programming ... that do not support Embedded SQL Microsoft SQL Server Embedded SQL for C has been deprecated as of Microsoft SQL Server 2008 although earlier versions of the product support it. ref cite web url http msdn.microsoft.com en us library ms143729.aspx title Deprecated Database Engine Features in SQL Server 2008 work SQL Server 2008 Books Online March 2009 publisher Microsoft accessdate 2009 04 10 ref MySQL MySQL does not support Embedded SQL. ref cite web url http dev.mysql.com tech resources articles precompiler for embedded sql.html title An Open Pre Compiler for Embedded SQL work MySQL DevZone Articles publisher Mysql accessdate 2009 04 10 ref Sybase Embedded SQL support has been discontinued ... to Pro C Embedded SQL http www.oreillynet.com pub a databases 2006 12 07 embedded sql with pro c.html ... 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 dictionary SQLSQL 2003 References references External links Category SQL database stub ru SQL Schemata ... 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 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 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 XML , or XML Related Specifications , extension to the SQL standard is defined by ISO IEC 9075 14 see SQL . SQL XML specifies SQL based extensions for using XML in conjunction with SQL. The XML data type is introduced, as well as several routines, functions, and XML to SQL data type mappings to support manipulation and storage of XML in a SQL database . The SQL XML specification includes functions to construct XML data. These functions allow the user to construct new XML elements or attributes with values e.g. from relational tables. Other functions such as XMLCONCAT or XMLAGG can be used to combine small XML fragments into larger ones. The list of available construction functions includes XMLELEMENT XMLATTRIBUTES XMLFOREST XMLCONCAT XMLNAMESPACES XMLCOMMENT XMLPI XMLDOCUMENT XMLAGG etc. SQL XML also defines functions which allow the user to embed XQuery expressions in SQL statements. These functions include XMLQUERY XMLTABLE While XMLQUERY returns values of type XML, the function XMLTABLE can take XML data as input and produce a relational table as output. Predicates on XML data, such as search conditions, can be expressed with the XMLEXISTS predicate, typically in the WHERE clause of a SQL statement. Further information and examples of the SQL XML functions are provided in the external links below. External links http www.sigmod.org publications sigmod record 0409 11.JimMelton.pdf at download file Jim Melton Jim Melton SIGMOD Record http www.sigmod.org publications sigmod record 0206 standard.pdf at download file SQL XML is Making Good Progress Andrew Eisenberg, Jim Melton SIGMOD Record 31 2 101 108 2002. http sqlxml.org SQLXML.org http sqlx.org SQLX.org References 1. Michael Wagner SQL XML 2006 Evaluierung der Standardkonformit t ausgew hlter Datenbanksysteme 1. Auflage, Diplomica Verlag, ISBN 3 8366 9609 6 database stub Category SQL de SQL XML ru SQL XML ... more details
SQL Plus is an Oracle database Oracle command line utility program that can run SQL and PL SQL commands interactively or from a script. SQL Plus operates as a relatively simple tool with a basic command ... in almost any Oracle software installation. Command 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 ... Bot retrieved archive archivedate 2007 11 09 ref SQL statements PL SQL blocks SQL Plus internal ... software environment can launch SQL Plus, for example, by entering code sqlplus scott tiger code where the Oracle user code scott code has the password 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 command. For example pre SQL> select Hello world as example from dual EXAMPLE Hello world pre History The first version of SQL Plus was called ... UFI changed to SQL Plus before the release of this Which? date July 2009 version. As of 2010 the product continues to bear the name SQL Plus . Usage Graphical interfaces from Oracle or third parties have diminished the proportion of Oracle database end users who depend on the SQL Plus environment. Oracle shops typically continue to use SQL Plus scripts for batch updating or simple reports. Citation needed date November 2008 Oracle Corporation s wrappers 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 Plus Worksheet accessdate 2008 11 21 author last ... location pages doi archiveurl archivedate quote Oracle s SQL Plus Worksheet is a straight forward, easy to use, graphical user interface for SQL. ref iSQL Plus or iSQLPlus, a web based utility ref cite ... archiveurl archivedate quote iSQLPlus iSQL Plus is a web based utility similar to the SQL Plus command ... 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 ... 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 Amazon S3 and Amazon Relational Database Service as a part of the Azure Services Platform . Unlike similar cloud based databases, SQL Azure allows relational database relational queries to be made against stored data, which can either be structured data structured or semi structured data semi structured , or even unstructured data unstructured document s. ref name faq cite web url http www.microsoft.com 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 Microsoft SQL Server as a backend, but it exposes only a subset of the data types &mdash including string, numeric, date and boolean. ref name ssds cite web url http blogs.msdn.com access archive 2008 03 06 sql server data services.aspx title SQL Server Data Services publisher MSDN Blogs author Ryan McMinn accessdate 2008 03 07 ref It uses an XML based format for data transfer. ref name faq Like Microsoft SQL Server , SQL Azure uses T SQL as the query language and Tabular Data Stream TDS as the protocol to access the service over internet. ref name faq ref cite web url http www.microsoft.com azure data.mspx title SQL Server Data Services publisher Microsoft accessdate 2009 04 16 ref It does ... www.microsoft.com azure sql.mspx SQL Azure Windows Azure Platform http blogs.msdn.com ssds default.aspx SQL Azure Team blog 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 http gemquery.com Gem Query Tool for SQL Azure Microsoft ... cloud services ja SQL Azure ru SQL Azure zh SQL Azure ... 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 developed by IBM for querying, altering and defining relational databases, using Declarative programming declarative statements. T SQL expands on the SQL standard to include Procedural programming procedural programming, local variable s, various support functions for string processing, date processing, 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 ... and UPDATE statements In Transact SQL, both the DELETE and UPDATE statements allow a FROM clause to be added ... f.id WHERE f.name Idle source BULK INSERT BULK INSERT is a Transact SQL statement that implements ... Server Enterprise Sybase PL SQL PL SQL Oracle SQLSQL ANSI Microsoft SQL Server SQL Server Microsoft ... 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 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 zh Transact SQL ... more details
dablink This article is about SQL 1999 , a revision of the SQL standard. For more information about SQL, see the main SQL article. SQL 1999 was the fourth revision of the SQL database query language . The latest revision of the standard is SQL 2008 . Summary The SQL 1999 standard, also known as SQL3, was published in 1999. Unlike previous editions, the standard s name used a colon instead of a hyphen for consistency with the names of other ISO standards. SQL 1999 has several parts ref Lans 2007, p.23. ref SQL Framework http www.iso.org iso iso catalogue catalogue tc catalogue detail.htm?csnumber 26196 ISO IEC 9075 1 1999 SQL Foundation http www.iso.org iso iso catalogue catalogue tc catalogue detail.htm?csnumber 26197 ISO IEC 9075 2 1999 SQL CLI an updated definition of the extension Call Level Interface, originally published in 1995, also known as CLI 95 http www.iso.org iso iso catalogue catalogue tc catalogue detail.htm?csnumber 30609 ISO IEC 9075 3 1999 SQL PSM an updated definition of the extension Persistent Stored Modules, originally published in 1996, also known as PSM 96 http www.iso.org iso iso catalogue catalogue tc catalogue detail.htm?csnumber 29864 ISO IEC 9075 4 1999 SQL Bindings http www.iso.org iso iso catalogue catalogue tc catalogue detail.htm?csnumber 26198 ISO IEC 9075 5 1999 Boolean data types The SQL 1999 standard clearly state in ISO IEC 9075 2 1999 section 4.6 Boolean types, but many commercial SQL Servers Microsoft SQL Server 2005 , Oracle Database Oracle 9i , IBM DB2 do not support it as a column type, variable type or allow it in the results set. MySQL interprets BOOLEAN as a synonym for TINYINT 8 bit signed integer . ref http dev.mysql.com doc refman 5.0 en other vendor data types.html ref Notes reflist References cite book last Lans first Rick F. van der title SQL for MySQL developers a comprehensive tutorial and reference publisher Addison ... Category SQL Category Declarative programming languages SQL compu lang stub database stub ru SQL 1999 ... 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
In various SQL implementations, a hint is an addition to the SQL standard that instructs the database engine on how to execute the query. For example, a hint may tell the engine to use as little memory as possible even if the query will run slowly , or to use or not use an index database index even if the query optimizer would decide otherwise. Different database engines use different approaches in implementing hints. MySQL uses its own extension to the SQL standard, where a table database table name may be followed by tt USE INDEX tt , tt FORCE INDEX tt or tt IGNORE INDEX tt keywords. ref MySQL 5.0 Reference Manual http dev.mysql.com doc refman 5.0 en index hints.html 12.2.8.2 Index Hint Syntax ref Oracle Database Oracle implements hints by using specially crafted SQL Other comment s in the query that begin with a tt tt symbol, thus not influencing SQL compatibility. ref Mike Ault http www.dba oracle.com t sql hints tuning.htm Oracle SQL Hints Tuning ref See also Query optimizer Query plan References reflist DEFAULTSORT Hint Sql Category SQL database stub ru SQL ... more details
An SQL INSERT statement adds one or more records to any single Table database table in a relational database ... code CHECK code constraints , and Null SQL code NOT NULL code constraints . If a syntax error ... instead. Example source lang sql INSERT INTO phone book name, number VALUES John Doe , 555 1212 ... 2 in the table. source lang sql INSERT INTO phone book VALUES John Doe , 555 1212 source Advanced forms Multirow inserts A SQL feature since SQL 92 is the use of row value constructors to insert multiple rows at a time in a single SQL statement source lang sql INSERT INTO table column a , column ... by IBM DB2 DB2 , Microsoft SQL Server SQL Server since version 10.0 ie. 2008 , PostgreSQL ... in the phone book table source lang sql INSERT INTO phone book VALUES John Doe , 555 1212 , Peter Doe , 555 2323 source which may be seen as a shorthand for the two statements source lang sql INSERT .... To insert multiple rows in MS SQL you can use such a construction source lang sql INSERT INTO phone ... SQL statement according to the SQL standard SQL 2003 due to the incomplete subselect clause ... lang sql INSERT INTO phone book SELECT John Doe , 555 1212 FROM DUAL UNION ALL SELECT Peter Doe , 555 ..., or as shown above source lang sql INSERT INTO phone book SELECT John Doe , 555 1212 FROM LATERAL ... SQL supports the INSERT ALL statement, where multiple insert statements are terminated by a SELECT ref cite web url http psoug.org snippet Oracle PL SQL INSERT ALL 589.htm title Oracle PL SQL INSERT ALL work psoug.org accessdate 2010 09 02 ref source lang sql INSERT ALL INTO phone book VALUES John ... and insert it directly into the table. All this is done in a single SQL statement that does not involve ... is started. An example is given below. source lang sql INSERT INTO phone book2 SELECT FROM phone book ... are not the same. source lang sql INSERT INTO phone book2 name , phoneNumber SELECT name , phoneNumber ... retrieve the database generated primary key from an SQL INSERT statement for use in another SQL ... more details
Encyclopedia
top
