Live briefing
Everything about Merge (SQL)
SQL statement
A relational database management system uses SQL MERGE statements to INSERT new records or UPDATE or DELETE existing records depending on whether condition matches. It was officially introduced in the SQL:2003 standard, and expanded in the SQL:2008 standard. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Merge (SQL)A 5-minute orientation
- Pick up a classic book: AQA A-Level Computer ScienceThe most-reprinted book on the subject
- Read the landmark paper: Merge replication in Microsoft's SQL server 7.0Cited 0 times
- Go sideways: Insert (SQL)A closely related topic
- Go sideways: Hierarchical and recursive queries in SQLA closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
📚 Books worth reading
AQA A-Level Computer ScienceBob Reeves · 2015
OCR AS and A Level Computer ScienceP.M. Heathcote, R S U Heathcote · 2016
Pro EJB 3 - Java Persistence APIMIKE KEITH,MERRICK SCHINCARIOL · 2006
Expert PHP and MySQLAndrew Curioso · 2010
LaTeX for Administrative WorkNicola L. C. Talbot · 2015
Using SCO UNIXGeoffrey T. LeBlond · 1990- 📕Microsoft Dynamics CRM 2013 unleashedMarc J. Wolenik · 2014
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Insert (SQL) An SQL INSERT statement adds one or more records to any single table in a relational database. Insert statements have the following form: INSERT INTO table…
- Hierarchical and recursive queries in SQL A hierarchical query is a type of SQL query that handles hierarchical model data. These are useful for working with databases of graph-structured data…
- Comparison of relational database management systems The following tables compare general and technical information for a number of relational database management systems. Please see the individual products'…
- Database trigger A database trigger is procedural code that is automatically executed in response to specific events on a table or view in a database. Triggers are commonly…
- SQL syntax The syntax of the SQL programming language is defined and maintained by ISO/IEC SC 32 as part of ISO/IEC 9075. This standard is not freely available. Despite…
- Select (SQL) The SQL SELECT statement returns a result set of rows, from one or more tables. A SELECT statement retrieves zero or more rows from one or more database…
- Prepared statement In database management systems (DBMS), a prepared statement, parameterized statement, (not to be confused with parameterized query) is a feature where…
- Virtual column In relational databases a virtual column is a table column whose value(s) is automatically computed using other columns values, or another deterministic…