SQL: Microsoft SQL Server vs MySQL Syntax

Concatenation of strings:

SQL Server

MySQL

Get length of a string:

SQL Server

MySQL

Limit number of records returned:

SQL Server

MySQL

Select a random record:

SQL Server

MySQL

Get a unique identifier (GUID):

SQL Server

MySQL

Get the current date and time:

SQL Server

MySQL

Identity (auto increment) column definition:

SQL Server

MySQL

Get the version of SQL Server/MySQL:

SQL Server

MySQL

Update query (using joins):

SQL Server

MySQL

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

CJayMead's SQL Server, Endeca, MS Office Help © 2018