/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

21 votes132 views6 answers
How to concatenate two lists in python
TypeScript
2 votes130 views1 answer
Promise to observable typescript
TypeScript
1 vote140 views1 answer
Sqlite.create "capacitor" cannot read property 'then' of undefined
TypeScript
0 vote118 views1 answer
Muliple time series plots in pandas
TypeScript
1 vote154 views1 answer
A device that interconnects two local area networks that both have a medium access control sublayer.
TypeScript
21 votes127 views2 answers
Voting results 2020 live
TypeScript
0 vote127 views2 answers
How to invert sortField primeng
TypeScript
21 votes139 views3 answers
Check port windows
TypeScript
0 vote120 views1 answer
Call function dynamically typescript
TypeScript
1 vote130 views2 answers
Append to lists python
TypeScript