Re: Migrating an Application from SQL Server 2000 to Oracle 10g
Date: Thu, 17 Jul 2008 12:06:27 -0700 (PDT)
> I just completed a review of a massive amount of SQL Server 2008
> docs and have an installed copy of the product that I am using
> to create a similar mapping page for the newest version. But,
> again, I see nothing like autonomous transactions, exception_init,
> serially reusable, or inline in the product.
BTW Daniel there is one thing with your excellent comparison paper - SQL Server 2005 of course doesn't have Hierarchical queries in form of start with ..connect by, but recursive queries can be performed using common table expressions (in oracle world these are called subquery factoring or WITH clause). So in general recursive queries are available also in SQL Server just with different mechanism. And I've also looked a bit in SQL Server 2008. It has quite nice Merge statement wich it seems works smarter than Oracle Merge (for example does only delete and not at first update and then delete).
http://www.gplivna.eu Received on Thu Jul 17 2008 - 14:06:27 CDT