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: )

556 reads

Blogs

Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2

By

(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...

Extended Events Misperceptions: Profiler is Easier, Part 2

By

I wrote a short blog post about the misperception that Profiler was easier than...

CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

By

If you read the title to this post and your first thought was That’s...

Read the latest Blogs

Forums

Fastest way to load a CSV file in SQL Server Table

By SQL Kidu

What is the fastest way to load a file in SQL Server Table ?...

Replication question

By pani

Im an Oracle DBA by trade and been tasked with setting up transaction replication...

Software to send Report

By VastSQL

Hi Experts, Currently we are using SQL Server and Database Mail to send reports...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers