PHP with MySQL vs. ASP/.NET with SQL.
If you're looking to learn a new skill to make yourself well
rounded, that's great. But if understand what you're saying, you're
looking to choose a path to take here.... take the time to look at
all your options. Once you start to head down one of these two
roads, you rarely look back. That's not to say there aren't
designers that can design sites using both ways, but you don't
usually find designers that are as versed with one as well as they
are the other. Consider trying your luck with both until you know
what works best for you... especially working with the servers and
software you will be using to run these languages. Both are
efficient at keeping your data organized and readily available
through a user interface, but they differ drastically in many
areas.
Following are some specific technical differences in MySQL
and SQL Server when it comes down to the ANSI SQL standard:
* MySQL does not support Triggers, SQL Server does.
* MySQL does not support User Defined Functions, SQL Server
does.
* MySQL does not have Cursor Support, SQL Server does.
* MySQL does not support Stored Procedures, SQL Server does.
* MySQL does not have FULL JOIN capabilities, SQL Server
does.
* MySQL has limited Import/Export capabilities, SQL Server
has full support for Import/Export.
* MySQL has limited Transaction Support while SQL Server
offers full Transaction Support.
So, it becomes clear that SQL Server is an obvious choice for
the company or individual that needs to have FULL control over
their data to manipulate and change it as they need. Now, does that
concern you? Maybe it does, or maybe this is more then you'll ever
do anyway. How about costs? MySQL is free, SQL is far from it.
Like I said, if you're choosing a path (and the more you
learn, the harder it feels to start over with a new language), you
better make sure it's the future you're looking for. Personally, I
think SQL provides a much more robust future as a designer, and the
software is much more user friendly. Take all of this into
consideration if you're only starting this process.