Newsletter #1, November 5, 2008
How to convert Oracle hierarchical query to SQL Server
Hierarchical query is a one of the most powerful feature supplied by Oracle to retrieve complex hierarchical data from a database. Oracle extended syntax of the SELECT statement allows user to construct compact queries using a set of the keywords, pseudocolumns, operators and functions. The results of the queries are ready to be used [...]
Emulation of Sybase ROLLBACK TRIGGER command in SQL Server 2005
ROLLBACK TRIGGER is one of those Sybase Adaptive Server Enterprise commands which do not have direct equivalent in SQL Server. SQL Server Migration Assistant does not support automatic conversion of this command, and the reason is impossibility to suggest one simple solution that is local for the module and good for all cases. Below I [...]