[Firebird-website] [FB-Tracker] Created: (WEB-89) old transition guides are to be updated for FB2.1/SQL-2008 MERGE statement

[Dmitry (JIRA) <tr...@fi...>]

old transition guides are to be updated for FB2.1/SQL-2008 MERGE statement
--------------------------------------------------------------------------

                 Key: WEB-89
                 URL: http://tracker.firebirdsql.org/browse/WEB-89
             Project: Web site
          Issue Type: Improvement
         Environment: FB 2.1+
            Reporter: Dmitry
            Assignee: Alexey Kovyazin


SQL 2008 MERGE statement was introduced in FB 2.1
Yet when googling about cross-tables UPDATE statement, it is not shown in results.

Old 2003-2005 articles pops up instead, such as 
http://www.firebirdsql.org/pdfmanual/MSSQL-to-Firebird-Russian.pdf
http://www.firebirdsql.org/manual/ru/migration-mssql-syntax-ru.html

The latter link, when opened directly from Google does not carry versions disclaimer and does not suggest developer to search for new versions features.

I think the paragraphs mentioning MS SQL extended UPDATE table1 FROM table2 statement should be extended with mentioning MERGE statement in FB 2.1
http://firebirdsql.su/doku.php?id=merge
http://www.mssqltips.com/sqlservertip/1704/using-merge-in-sql-server-to-insert-update-and-delete-at-the-same-time/
http://en.wikipedia.org/wiki/Merge_(SQL)

The whole guide rewriting seems low priority task, that probably would never be done completely.
But this particular problem is too easy to find in Google and i think can be fixed in advance to other obsolete things in those article instances.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira