Syntax Difference between MS Sql and My Sql

please check the following links,

http://vijaymodi.wordpress.com/2007/11/24/syntax-difference-between-ms-sql-and-my-sql/

http://www.mssqltips.com/sqlservertutorial/2204/mysql-to-sql-server-coding-differences/