/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

0 vote207 views1 answer
Objects all django what is returned
TypeScript
3 votes204 views1 answer
Adonis validator opcional
TypeScript
1 vote195 views3 answers
An attempt was made to access a socket in a way forbidden by its access permissions
TypeScript
0 vote189 views1 answer
Target.value typescript
TypeScript
4 votes195 views4 answers
Array.prototype.map() expects a return value from arrow function array-callback-return
TypeScript
2 votes203 views1 answer
Serenity-is hide column
TypeScript
0 vote312 views1 answer
Java read all objects on a file
TypeScript
1 vote224 views2 answers
View all foreign key constraints postgres
TypeScript
3 votes196 views2 answers
Write an SQL query to fetch details of employees whose name starts with an alphabet 'A' and contains 10 alphabets.
TypeScript
0 vote206 views1 answer
How to Write a program that accepts three decimal numbers as input and outputs their sum on python
TypeScript