/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

12 votes283 views2 answers
How to make a bool appear in all scripts unity
TypeScript
5 votes271 views1 answer
Heroku database error unknow attribute first_name for user
TypeScript
4 votes290 views4 answers
ERROR in The Angular Compiler requires TypeScript >=4.0.0 and <4.1.0 but 3.4.5 was found instead.
TypeScript
5 votes271 views2 answers
Convert object object to array typescript
TypeScript
0 vote307 views1 answer
How should a developer write unit tests for a private method in an apex class
TypeScript
32 votes305 views6 answers
Bootstrap alerts
TypeScript
0 vote277 views1 answer
> Could not find method classpath() for arguments [org.jetbrains.kotlin:kotlin-gradle-plugin:1.6.10] on object of type org.gradle.api.internal.artifacts.dsl.dependencies.DefaultDependencyHandler.
TypeScript
8 votes277 views2 answers
List of objects to string c#
TypeScript
0 vote261 views1 answer
Online doctor appointments in pakistan
TypeScript
0 vote273 views1 answer
Ionic 4 reset form
TypeScript