Question

Name the function which is very useful to create CSV file from table?

Answer 1

Function name is CONCAT_WS which is launched in SQL Server 2017 version. Now come to functional part its takes a variable number of arguments and concatenates them in single string by using the first argument as separator. This will requires separator and a minimum of two arguments.

And this function is very helpful in creating a comma or pipe separated csv file content.