sqlserver and oracle compatibility

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

sqlserver and oracle compatibility

Author

Topic

sql777
Constraint Violating Yak Guru

314 Posts

Posted - 2004-12-12 : 09:48:21

Hi,

Are there any tips tricks to keep my sql code compatible with both sqlserver and oracle?

any links would be great!

i guess using temp tables is out of the question?

nr
SQLTeam MVY

12543 Posts

Posted - 2004-12-12 : 09:58:10

And lots of other things.
One problem is that they handle nulls differently as well as a lot of the sql being different.

http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm
http://www.webucator.com/resources/sql/reference.html
http://www.akadia.com/services/sqlsrv2ora.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources