Display Database column as comma separated value in SQL Server

Question

HiI have one tableId   Email1     aaagmailcom2     bbgmailcomi have one button after clicking of that button i need to fetch all emails from database and display it with comma separated valuesEx opaaagmailcombbgmailcom

dharmendr · Accepted Answer

Hi mahesh213Use query like below and implement in your code to dispaly the recordDECLARE CSV VARCHARMAX SELECT CSV  COALESCECSV  39 39 3939  FirstName from EmployeesSELECT CSV AS Result

Display Database column as comma separated value in SQL Server

Company

Explore

Follow us

Contact Us