/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 vote298 views1 answer
What does virtual assistants do?
TypeScript
0 vote320 views1 answer
Install typescript in ubuntu using sudo command
TypeScript
1 vote277 views2 answers
Github django projects
TypeScript
0 vote309 views1 answer
Sockjs-node/info?t=net::ERR_CONNECTION_TIMED_OUT
TypeScript
2 votes309 views1 answer
How to link locally installed fonts to css
TypeScript
-1 vote316 views1 answer
Components react to hooks
TypeScript
0 vote317 views3 answers
Check table exists in db laravel
TypeScript
0 vote310 views1 answer
In what phaseof meiosisof prophase1 homologous chrosomes gets close to each other
TypeScript
2 votes321 views3 answers
Module not found: Error: Can't resolve 'core-js/es7/reflect'
TypeScript
0 vote326 views1 answer
Init Lambda based on typescript
TypeScript