When you are migrating from the Microsoft SQL to MySQL server, the SQL queries are to be converted to MySQL syntax. Even if the SQL queries and the MySQL syntax are similar in nature, they are not completely identical. The differences between them can be identified through the Oracle ERP database management system. Now, let us go through all the differences.
LEN () Function
DATEADD (year, 2 , %expression% ) -> %expression% + interval 2 years
DATEADD (month, 2 %expression %) -> %expression% + interval 2 months
DATEADD (day, 1, %expression%) -> %expression% + interval 2 days
Top (100) PERCENT
SET @ amount = ( SELECT COUNT (*) FROM ( %tablename%) * %percentage% / 10
PREPARE STMT FROM %originalquery% FROM %tablename% LIMIT
EXECUTE STMT USING @amount
Therefore, being similar database management systems, the queries and the syntaxes of MS SQL and MySQL are slightly different. Now, as you know the process of converting the queries from one another, you can use any of them without any hindrance.
Lalit Sharma is an SEO consultant who runs a SEO house called Ranking By SEO. He is specialized in link building and other SEO related activities. You can also find him on Twitter, Google+ and his personal site.