Differences between Microsoft SQL server and Oracle database server 1

[RY]

I have been working on Oracle database as a developer and I may have to work on MS SQL server! I would like to know what are the major differences in Query writing and customization using stored procedures etc between Oracle and MS SQL server?

 

[Euripedes]

The queries are about the same but the functions are screwy (Conversions, substrings, dates and date formatting)

 

[mark06]

I'm in the middle of sorting out a very annoying problem. In Oracle, a select statement using IN will parse the query to use indexing where it exists, but SQLServer does full table scans and ignores the indexes. Using UNION in SQLServer for every component of the IN clause performs the same as Oracle. Does anyone haves any smart ideas on rewriting these queries in SQLServer ?

 

[jnicho02]

Could try splitting the query into two statements. SELECT the ids from the inner statement into a temp table, then use it as part of the join in the main SELECT.

 

[mark06]

Thanks for the tip - it pointed me in a direction where I realised my SQL statement was badly flawed (grouping on a dataset that was already grouped). Je suis un buffoon!

 

[MapMan]

Bouffon, Aucun Non. Mais, deux têtes sont meilleures qu'un.

 

[TeaAddictedGeek]

Vous avez raison, MapMan.