what is the difference between sql server and MY SQL?

Hi Richa,

Please refer the below link

http://blog.sqlauthority.com/2009/09/09/sql-server-difference-between-sql-server-express-and-mysql/

Thanks

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