what is the difference between sql server and MY SQL?

Question

Satyapriya Nayak · Answer

Hi Richa Please refer the below link http://blog.sqlauthority.com/2009/09/09/sql-server-difference-between-sql-server-express-and-mysql/ Thanks

Muralidharan Deenathayalan · Answer

There are lot of differences. Cost wise : MySql is open source where as sql server is not. Technical differences 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 http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html