Now I like to give the syntax difference between these two databases. Let me start it now…
> If you want to retrieve the first (Top) four rows from a table by using query you have to write TOP in MS Sql. While for the same purpose, you need to write LIMIT in mysql. The syntax are as follows:
SELECT TOP(4) * FROM TableName ORDER BY FieldName
SELECT * FROM TableName ORDER BY FieldName LIMIT 4
> My Sql can insert multiple rows at a time, while MS Sql cannot.
INSERT INTO tablename VALUES (1,'AAA');
INSERT INTO tablename VALUES (2,'BBB');
INSERT INTO tablename VALUES (3,'CCC');
INSERT INTO tablename
VALUES (1,'AAA') , (2,'BBB') , (3,'CCC');
> MSSQL doesn't have CHARACTER_LENGTH. Provides the Provides CHARACTER_LENGTH.
DATALENGTH functions instead (the latter is especially valid for 'special' data types like the
TEXT type).while MYSQL
Aliases: CHAR_LENGTH, LENGTH. Note that MySQL removes trailing (not leading) spaces from CHAR values before counting.
To See the other more important difference visit the following link: