question

katmanjones avatar image
katmanjones asked

Oracle 10g to MS SQL 2005

I have recently started a new job. My previous position wrote SQL in Oracle 10g and my new job writes in MS SQL Server Management Studio 2005. My first question is are there any good references or documents which expalin the difference in query writing from Oracle to MS? My second questions is regarding the WITH Clause. I used this a lot in Oracle 10g and was wondering what the equivalant was in MS SQL Server Management Studio 2005? Please can you show an example also? Many Thanks katmanjones
queryoraclessmswith-clause
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sqlaj 1 avatar image
sqlaj 1 answered
There are many things different in SQL code when working with SQL Server and Oracle. It would be better to research a good reference for both individually. Then when you run into an issue like your other question about WITH Clause, review the documentation for that statement. SQL Server: http://msdn.microsoft.com/en-us/library/s0kb861t(v=vs.80).aspx Oracle: http://www.dba-oracle.com/t_with_clause.htm
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.