Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / how to concatenate text from multiple rows into a single text string in sql server
Ask Question

How to concatenate text from multiple rows into a single text string in SQL Server

Sandra Emily 659 15 Jul 2024

How to concatenate text from multiple rows into a single text string in SQL Server

mssql server mssql serversql serversql
Updated 15 Jul 2024
Sandra Emily
Sandra Emily

Student

Content writing is the process of writing, editing, and publishing content in a digital format. That content can include blog posts, video or podcast scripts, ebooks or whitepapers, press releases, product category descriptions, landing page or social media copy and more.

Message

1 Answers

Ashutosh Patel
Ashutosh Patel 15 Jul 2024
Report Abuse

You can contact multiple row values into a single text string value by using the SQL built-in function STRING_AGG(). 

Note- STRING_AGG() function supported in SQL Server version 2017 and later

Syntax- 

SELECT STRING_AGG(column_name, ', ') as ConcatedText FROM table_name

The STRING_AGG() function requires 2 argument(s), the first one is the column name and the second one is a separater between values as you see in the above syntax.

Example-

suppose we have a Employees table. 

CREATE TABLE Employees
(
	EmpId INT PRIMARY KEY NOT NULL,
	EmpName NVARCHAR(50), 
	Gender NVARCHAR(20),
	Salary DECIMAL(10, 2)
)

Let's insert some values into above table,

INSERT INTO Employees
VALUES('Priya Shukla', 'Female', 70788),
('Ashutosh Verma', 'Male', 50066),
('Rani Sharma', 'Female', 57722),
('Amit Tiwari', 'Male', 81391),
('Ashu Patel', 'Male', 57659),
('Samiksha Mishra', 'Female', 15000),
('Akanksha Singh', 'Female', 15000);

As you can see in the below picture,

Ashutosh Patel

Example-

Now, use STRING_AGG() to concat multiple row values into a single string,

SELECT STRING_AGG(EmpName, ', ') as ConcatedText FROM Employees

-- output: Priya Shukla, Ashutosh Verma, Rani Sharma, Amit Tiwari, Ashu Patel, Samiksha Mishra, Akanksha Singh

Also, Read: How to use searching and filtering data in an SQL server?

advertising