Learn more about SQL Server tools

 
 

Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories

 

MySQL to SQL Server Coding Differences



By:

Overview

There are certain differences between some commonly used SQL code in Microsoft SQL Server's Transact SQL and MySQL.

Explanation

The following code snippets show examples of some commons functions which are different in the two database management systems. The first code is for MySQL and the second code is for MS SQL.

Length of a string:

SELECT CHARACTER_LENGTH(string_data)
FROM TestTable

SELECT LEN(string_data)
FROM TestTable

Concatenation of strings:

SELECT CONCAT('MS','SQL','Tips')

SELECT ('MS' + 'SQL' + 'Tips')

Select first 10 records from a table:

SELECT * FROM TestTable WHERE id=12 LIMIT 10

SELECT TOP 10 * FROM TestTable WHERE id=12

Generate Globally Unique Identifier (GUID):

SELECT UUID()

SELECT NEWID()

Select a random record:

SELECT * FROM TestTable ORDER BY RAND() LIMIT 1

SELECT TOP 1 * FROM TestTable ORDER BY NEWID()

Return current date and time:

SELECT NOW()

SELECT GETDATE()

Auto increment field definition:

TestTable INTEGER AUTO_INCREMENT PRIMARY KEY

TestTable INT IDENTITY PRIMARY KEY

Database version:

SELECT VERSION()

SELECT @@VERSION

Please note that MS SQL does not support the commenting option using #, but -- and /*  */ work the same way.




More SQL Server Solutions




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


Get free SQL tips:

*Enter Code refresh code     



Monday, April 25, 2016 - 3:03:27 AM - karthikaqpt Back To Top

SQL and Mysql:

Take a look at the top-n section. In MySQL:

 

SELECT age

FROM person

ORDER BY age ASC

LIMIT 1 OFFSET 2

In SQL Server (T-SQL):

 

SELECT TOP 3 WITH TIES *

FROM person

ORDER BY age ASC 

Learn sql from https://www.youtube.com/watch?v=7Vtl2WggqOg


Learn more about SQL Server tools