Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

old transition guides are to be updated for FB2.1/SQL-2008 MERGE statement [WEB89] #151

Open
firebird-automations opened this issue Oct 24, 2011 · 0 comments

Comments

@firebird-automations
Copy link

Submitted by: Arioch (arioch)

Assigned to: @alexeykovyazin

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.

@mrotteveel mrotteveel transferred this issue from FirebirdSQL/web Apr 25, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant