Excellent! Now you know the difference.
When you use
CONCAT(), it might be problematic and unreadable to add a space after each column you want to concatenate. Since SQL Server 2017, there is a special function that allows you to enter the separator only once, as a first parameter. Then SQL Server will automatically place that separator between all the joined values in the text. The name of this function is
You can see it in the example below:
CONCAT_WS(N' ', Id, Type, CopywriterId) AS Description
|1 tv commercial 3
|2 tv commercial 6