SQL Server: Get Row Values as Comma Separated String

Question

How to show all the names in colunm n tat names should b seperated by coma  using SQL query eg Names ABC opABC

Mudassar · Accepted Answer

You can make use of COALESCE function in SQL ServerUSE NORTHWINDGODECLARE ListIds VARCHARMAXSELECT ListIds  COALESCEListIds3939 3939  CustomerIDFROM CustomersSELECT ListIdsGO

SQL Server: Get Row Values as Comma Separated String

Company

Explore

Follow us

Contact Us