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.