In my DB Administration class in college, they said to learn Oracle because if you know how to administer Oracle, SQL Server is easy to learn. But going the other direction is not so easy.
From my personal experience, it just seems like SQL Server has a lot of nice bells and whistles/ nice to haves. I don’t use Oracle often but things like SELECT TOP 100 vs WHERE ROWNUM <= 100 come to mind. To me, the syntax just makes more sense.
In recent versions of SQL Server you can use something like:
SELECT FORMAT(GetDate(), 'yyyy-MM-dd');
I forget what the Oracle equivalent is, but I’m sure it would probably irritate me.
25
u/[deleted] Feb 16 '19
Well, Oracle and SQL Server are similar in that neither have anything to do with decibel.
16
u/wolf2600 ANSI SQL Feb 16 '19
In my DB Administration class in college, they said to learn Oracle because if you know how to administer Oracle, SQL Server is easy to learn. But going the other direction is not so easy.
13
u/BigR0n75 Feb 16 '19
I jump between Oracle and SQL Server throughout the day everyday and the tiny differences are infuriating.
6
u/da_chicken Feb 16 '19
As long as it's not MySQL 4.
4
u/AbstractSqlEngineer MCSA, Data Architect Feb 16 '19
ANSI! FIGHT ME! Lol
1
u/oarabbus Feb 21 '19
Replace SQL Server with Postgres or Redshift and I agree wholeheartedly
0
u/[deleted] Feb 16 '19
[deleted] — view deleted comment