/TypeScript/Sql server results to comma delimited string

Sql server results to comma delimited string

DECLARE @csv VARCHAR(MAX)
SELECT @csv = COALESCE(@csv + ',' ,'') + book_title from Test.dbo.Books where book_id IN ( 101, 102, 103);
SELECT @csv 

Output
Head First SQL, SQL Puzzler, T-SQL Fundamentals

Source: javarevisited.blogspot.com

Similar codes

1 vote314 views3 answers
Convert javascript to typescript online converter
TypeScript
0 vote219 views1 answer
How to get the sheets no in excel package workbook in c#
TypeScript
0 vote210 views1 answer
How to make the inputs become a sum python
TypeScript
1 vote176 views1 answer
Why is a tree set sorted
TypeScript
0 vote205 views1 answer
What are appropriate timing of alerts of alertmangaer
TypeScript
0 vote261 views2 answers
Angular 9 : Error NG2003: No suitable injection token for parameter 'url' of class 'DataService'. Found string
TypeScript
16 votes224 views1 answer
Python for with two arrays
TypeScript
49 votes243 views6 answers
How to get duplicate values in sql
TypeScript
20 votes217 views2 answers
Typescript how to color your console loggers
TypeScript
4 votes259 views3 answers
How to find employee names starts with in sql
TypeScript