JohnBat26 / gentoo-doc

Automatically exported from code.google.com/p/gentoo-doc
0 stars 0 forks source link

MS SQL to FirbirdSQL guide to be updated #6

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
svn-history/r2/trunk/src/docs/gentoo-doc/migrationmssql.xml

This is copy of article of 2005

It shows MS SQL UPDATE statement as more flexible than FB SQL. That's true.
However SQL 2008 came with MERGE statement, implemented in FB 2.1

It is to be referenced, otherwise the solution in the article are inadequate to 
current FB versions.

http://firebirdsql.su/doku.php?id=merge
http://www.mssqltips.com/sqlservertip/1704/using-merge-in-sql-server-to-insert-u
pdate-and-delete-at-the-same-time/
http://en.wikipedia.org/wiki/Merge_(SQL)

Original issue reported on code.google.com by Arioch...@gmail.com on 24 Oct 2011 at 7:37