Returning a Comma Delimited string

One of the small quirks of SQL is that it can add each row to a variable.In the most common case, this is used to generate a comma delimited list.The script shows how to do this wiht a scalar function, so that multiple rows are returned.The script shows calculating the column sum the hard way […]

2007-03-26 (first published: )

562 reads

Blogs

The Diverse Data Platform–Dativerse.io

By

The other day I got a note from Ben Weissman the other day that...

Extended Events and Azure SQL Database

By

Knowledge of how your system behaves is vital to better control, maintain, and grow...

Daily Coping 19 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Replication - not all columns are updating

By screenshot

I've set up replication but I'm having difficulties in my testing. I've changed 3...

The Security of Source Code

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Security of Source Code

Running SSIS in ADF

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Running SSIS in ADF

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers