aspose file tools*
The moose likes JDBC and the fly likes Oracle and SQLServer 2005 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle and SQLServer 2005" Watch "Oracle and SQLServer 2005" New topic
Author

Oracle and SQLServer 2005

Arjun Reddy
Ranch Hand

Joined: Nov 10, 2007
Posts: 627
Hi all,

Till now, I have only been writing queries for Oracle database. Now I am planning to start writin queries for SQLServer 2005 database and I was wondering if the queries syntax would be same. Also if there is a good tutorial for SQLServer2005, Can someone please post a link here?

Thanks.


Be Humble... Be Nice.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38793
    
  23
fficial&client=firefox-a" target="_blank" rel="nofollow">Google is your friend.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

There is also extensive T-SQL documentation on MSDN.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Arjun Reddy
Ranch Hand

Joined: Nov 10, 2007
Posts: 627
Originally posted by Paul Sturrock:
There is also extensive T-SQL documentation on MSDN.


But T-SQL is similar to Pl/sql right?/ My question is if the normal sql we use, the crud operations, joins etc... if their syntax is same for both oracle and sql server 2005.

Thanks.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Both servers support ANSI92 SQL, so assuming you have used ANSI92 SQL then yes, it should be fine.

If you have to support portability accross more than one database type you could look at JPA.
 
wood burning stoves
 
subject: Oracle and SQLServer 2005