Multiple issues unreferenced December 2009 cleanup March 2008 context October 2009 MetaSQL Use with reference to PeopleSoft MetaSQL expands to platform specific SQL substrings, causes another function to be called, or substitutes a value. MetaSQL 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. MetaSQL Element Types There are three types of metaSQL 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. MetaSQL Placement Considerations Not all metaSQL can be used by all programs. Some metaSQL can be used only in Application Engine programs. Other metaSQL can only be used as part of a SQL statement in a SQL or dynamic view. The following table lists available metaSQL elements and where each element can be used. If a metaSQL 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 metaSQL element is used in PeopleCode, you cannot use metaSQL like a built in function. You can use metaSQL in the SQLExec function, the Select method, the Fill method, and so on. Note MetaSQL is not available in SQR DEFAULTSORT MetaSql Category SQL ... more details
About the database language the IATA code San Carlos Airport Infobox programming language name SQL paradigm ... SQL 2011 latest release date 2011 turing complete No typing Static typing Static , strong typing strong implementations List of relational database management systems Many dialects SQL 86, SQL 89, SQL 92 , SQL 1999 , SQL 2003 , SQL 2008 , SQL 2011 influenced by Datalog influenced Agena programming ... 45498 title ISO IEC 9075 1 2008 Information technology Database languages SQL Part 1 Framework SQL ... to end in a . , as necessary. inconsistent citations file ext .sql Infobox file format name SQL screenshot caption Structured Query Language extension .sql mime application x sql uniform type owner ... SQL 2008 latest release date Start date and age 2008 df yes genre Database standard ISO IEC 9075 ... 45498 title ISO IEC 9075 1 2008 Information technology Database languages SQL Part 1 Framework SQL ... to end in a . , as necessary. inconsistent citations ref SQL IPAc en icon s k ju l S Q L ref cite book last Beaulieu first Alan title Learning SQL editor Mary E Treseler publisher O Reilly location ... and delete , database schema schema creation and modification, and data access control. SQL was one ... 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 ... c0004100.htm date October 27, 2006 accessdate 2007 06 10 ref Although SQL is often described as, and to a great ... programming procedural elements. SQL became a Technical standard standard of the American National ... then, the standard has been enhanced several times with added features. However, issues of SQL ... specification of the standard, as well as vendor lock in . History SQL was initially developed at IBM ... 06 09 ref The acronym SEQUEL was later changed to SQL because SEQUEL was a trademark of the United ... language known as QUEL query languages QUEL , which was later supplanted in the marketplace by SQL ... more details
about the word or prefix MetaMeta disambiguation selfref For information on the wiki based web site for the coordination of all the Wikimedia Foundation projects, see Wikipedia Meta . wiktionarypar metaMeta from Greek language Greek after , beyond , adjacent , self , is a prefix used in English ... another concept, used to complete or add to the latter. In epistemology , the prefix meta is used ... subject can be said to have a meta theory which is the theoretical consideration of its meta properties ... language Greek , the prefix meta is generally less esoteric than in English language English Greek meta is equivalent to the Latin language Latin words post or ad . The use of the prefix in this sense ... meta merely in the sense that the Metatheria occur on the tree of life adjacent to the Theria the placental mammals . Meta is also gaining currency as an adjective, as well as a prefix, as in the work of Douglas Hofstadter see Meta Quine and Hofstadter below . TOC Etymology The prefix comes from the Greek language Greek preposition and Prefix linguistics prefix meta , from , ref http www.perseus.tufts.edu ... of the word meta is the Mycenaean Greek me ta , written in Linear B syllabic script. ref http www.palaeolexicon.com ... ref Quine and Hofstadter The OED cites uses of the meta prefix as beyond, about such as meta economics and meta philosophy going back to 1917. However, these formations are directly parallel to the original ... of Symbolic Logic, Vol. 2, No. 4, pp. 145 152, December 1937 ref where meta clearly has the modern meaning of an X about X . Note that earlier uses of meta economics and even metaphysics do not have ... recent coinages which use it. fact date May 2010 Hofstadter uses meta as a stand alone word, both as an adjective and as a directional preposition going meta , a term he coins for the old rhetorical ... of meta with self reference, as opposed to just abstraction. fact date May 2010 The sentence This sentence ..., the acronym I m So Meta, Even This Acronym, which spells IS META. ref http xkcd.com 917 Munroe ... 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
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. Implementations PostgreSQL has support for some SQL MED since version 9.1. 9.2 supports more ref http wiki.postgresql.org wiki SQL MED PostgreSQL Wiki SQL MED ref . See also SQLSQL 2003 References references External links http www.sigmod.org publications sigmod record 0209 jimmelton.pdf view SQL MED A Status Report Category SQLSQL database stub ru SQL MED ... 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
unreferenced date July 2010 The SQL CLI , or Call Level Interface , is an extension to the SQL standard is defined in SQL 1999 based on CLI 95 , but also available in later editions such as 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 Call Level Interface SQLSQL 2003 References Empty section date July 2010 External links Category SQLSQL database stub ru SQL CLI ... 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 SQLSQL database stub ru SQL Schemata ... 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 SQL database stub Category SQL ru SQL OLB ... 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
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
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. SQL JRT is implemented in HSQLDB ref name hsqldbmanual http hsqldb.org doc guide sqlroutines chapt.html src jrt routines HSQLDB manual ref . Example SQL JRT allows a Java function to be called from SQL code like this ref name hsqldbmanual code copied from HSQLDB manual, which is BSD licensed source lang sql CREATE FUNCTION sinh v DOUBLE RETURNS DOUBLE LANGUAGE JAVA DETERMINISTIC NO SQL EXTERNAL NAME CLASSPATH java.lang.Math.sinh SELECT sinh doublecolumn FROM mytable source SQL JRT also allows Java code to dynamically generate tables using a code java.sql.ResultSet code object. The result sets returned are converted to SQL tables and can be used anywhere a table or view can be used ref name hsqldbmanual . See also SQL 2003 References references External links http www.podgoretsky.com ftp docs DB SQL2003 5WD 13 JRT 2003 09.pdf SQL 2003 SQL JRT draft http farrago.sourceforge.net design UserDefinedTypesAndRoutines.html SQL 2003 SQL Standard User Defined Types and Routines from the Farrago software Farrago documentation DEFAULTSORT Sql Jrt Category SQLSQL database stub ru SQL JRT ... more details
SQL PSM stands for SQL 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 SQL 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
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
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 2011 . Summary contradict other Merge SQL The SQL 2003 standard makes minor modifications to all parts of SQL 1999 also known as SQL3 , and officially introduces ... standards last Eisenberg first Andrew coauthors et al. title SQL 2003 Has Been Published format ... 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 ... 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 ... . The zip archive contains a number of Portable Document Format PDF files that define the parts of the SQL ... 34132 ISO IEC 9075 1 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 ... Interface SQL CLI http www.iso.org iso en CatalogueDetailPage.CatalogueDetail?CSNUMBER 34135 ISO IEC 9075 4 2003 &ndash Persistent 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 ... Object Language Bindings SQL OLB http www.iso.org iso en CatalogueDetailPage.CatalogueDetail?CSNUMBER 34917 ISO IEC 9075 11 2003 &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 language Java Programming Language SQL JRT http www.iso.org iso ... SQL XML References reflist External links http savage.net.au SQLsql 2003 1.bnf.html BNF Grammar ... 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
An SQL UPDATE statement changes the data of one or more records in a Table database table . Either all the rows can be updated, or a subset may be chosen using a condition SQL condition . The code UPDATE code statement has the following form ref http dev.mysql.com doc refman 5.0 en update.html simplified from this page ref code UPDATE code table name code SET code column name value , column name value ... code CHECK code constraints , and Null SQL code NOT NULL code constraints . In some databases, such as PostgreSQL ... docs 8.1 static sql update.html ref Because of this indeterminacy, referencing other tables only within ... lang sql UPDATE T SET C1 1 WHERE C2 a source In table T , set the value of column C1 to 9 and the value of C3 to 4 for all rows for which the value of column C2 is a . source lang sql UPDATE T SET C1 ... sql UPDATE T SET C1 C1 1 WHERE C2 a source Prepend the value in column C1 with the string text if the value in column C2 is a . source lang sql UPDATE T SET C1 text C1 WHERE C2 a source Set the value ... in column C3 in table T2 having the column C4 equal to 0. source lang sql UPDATE T1 SET C1 2 WHERE ... source lang sql UPDATE T SET C1 1, C2 2 source Complex conditions and JOINs are also possible source lang sql UPDATE T SET A 1 WHERE C1 1 AND C2 2 source Some databases allow the non standard use of the FROM clause source lang sql UPDATE a SET a. updated column updatevalue FROM articles a JOIN ... there is an index on classification.articleID source lang sql UPDATE SELECT FROM articles JOIN classification ... of UPDATE statements to become an infinite loop when the where SQL WHERE clause and one or more SET clauses may utilize an intertwined Index database index . References reflist SQL DEFAULTSORT Update Sql Category SQL keywords Category Articles with example SQL code cs UPDATE ko Update SQL hr Update SQL kk , lv Update SQL nl Update SQL ja UPDATE SQL no Update SQL pt Update SQL ru Update SQL sq Update SQL sr Update SQL uk Update SQL zh SQL ... more details
In database query operations, various SQL implementations use hints as additions to the SQL standard that instruct 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 to use an index database index even if the query optimizer would decide otherwise . Implementation 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.5 Reference Manual http dev.mysql.com doc refman 5.5 en index hints.html 12.2.9.3 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 affecting 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
Encyclopedia
top
