This is one the new feature in SQL Server 2012 by which you can concatenate values. The USP of the function is that it handle the NULL values also. means if you are concatenating values in which null also exists then it handle those null value also means it concatenates only those values which …