CONCAT() fucntion is introduced in SQL Server 2012. Before to this version, concatenation of two strings is to be done by using + ( plus)
Syntax:CONCAT ( string1, string2[, string-n])
SELECT CONCAT( 'FirstName', ' ', 'LastName' ) FullName
There are some differences between Plus operator's concatenation and CONCAT function...
The equivalent SQL for the above SELECT using Plus operator is as follows:
SELECT 'FirstName' + ' ' + 'LastName' as FullName
Usage: Mainly used to generate comma separated values of all or some of the columns in a table
SELECT Conact(EmpID , ' ,', FirstName, ' , ' , LastName, ' , ', Salary) CSVData