ODBC Escape sequences has included in ODBC standard and allows write SQL queries which compatible with many DBMS. Firebird and Interbase does not contains own implementation for escape sequences and therefore we have implemented them in IBProvider and now
SQL Server Integration Services (SSIS) - is a comfortable way for developing ETL processes. Integrations Services Projects are well integrated with other development tools of SQL Server 2005 - Analysis Services (SSAS) and Reporting Services (SSRS). Excel
New SQL instructions and features were added to Firebird 2.0: Derived Tables, EXECUTE BLOCK, INSERT RETURNING, ROLLBACK RETAIN, ROWS. Lets write a few c# examples for ADO .Net