Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle and SQLServer 2005

 
Arjun Reddy
Ranch Hand
Posts: 629
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Campbell Ritchie
Sheriff
Posts: 48424
56
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There is also extensive T-SQL documentation on MSDN.
 
Arjun Reddy
Ranch Hand
Posts: 629
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic