Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

String_AGG function in Sql Server

Home
Forums

String_AGG function in Sql Server

Sonu Sharma

Sonu Sharma

6yAsked Aug 18, 2020, 2:59 AM1.2k

what is String_AGG function in sql server and how we can use it ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Varun Setia6y ago
Accepted answer
Hi,

This is available from SQL Server 2017 onwards.

Applies to:
SQL Server 2017 (14.x) and later
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Check this:

https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15

Example
USE AdventureWorks2016
GO
SELECT STRING_AGG (CONVERT(nvarchar(max),FirstName), CHAR(13)) AS csv
FROM Person.Person;
Sometimes, we get issue that it is not working,

https://stackoverflow.com/questions/40923080/string-agg-is-not-a-recognized-built-in-function-name
0
Navaneeth Krishnan6y ago
https://www.sqlservertutorial.net/sql-server-string-functions/sql-server-string_agg-function/
-1