--fred
see also
last updated: 3/3/2001
applies to: oracle 7.3+, ms sql server 6.5+
the following are good sources of info about differences between oracle and ms sql server:
- bowman, judith s., sandra l. emerson, and marcy darnovsky. the practical sql handbook. addison-wesley publishing company, 1993. isbn 0-201-62623-3.
this book gives a good introduction to sql, with a slight emphasis on sybase, but with a useful summary in the back of the syntax for each of the sql statements (select, insert, update, delete, create, drop, grant, revoke, etc.) for each of the major databases (oracle, sybase, db2, informix, ingres, etc.) the book pre-dates ms sql server, but the sybase info is a good approximation since ms sql server is a derivative of sybase.
- "migrating oracle applications to sql server" on msdn cd, and at ms technet web site:
http://www.microsoft.com/technet/sql/tools/sqldevkt/orcl2sql.asp
