As a regular reader you may know that I now a days work with MySQL and SQL Server both at the same time. Working with two different products have changed quite a few things in how I write code. Here is an example of that – I changed myself about how I CONCAT strings.
Earlier with SQL Server
Earlier I used to use ‘+’ (Plus) operator when I was concatenating strings. Here is the script for the same:
SELECT 'FirstName' + ' Last Name' AS FullName;
Now with SQL Server
SELECT CONCAT('FirstName',' Last Name') AS FullName;
The reason I use the CONCAT function instead of ’+’ (Plus) operator is because CONCAT functions work in MySQL as well.
Here is the example how the same scripts work in MySQL without changing any code.
Reference: Pinal Dave (http://blog.sqlauthority.com)