STRING_AGG(expression, separator [order_by_clause]) is an aggregate function that concatenates a list of strings(string cells in one column) and places a separator between them, where [order_by_clause] is optional and it is for specifying the order of concatenated results.
Copy Data Between Remote DB Servers Without Creating Temporary File