SQL Server - STRING_AGG function in SQL server

Опубликовано: 10 Октябрь 2024
на канале: PracticalIT
253
1

In this tutorial, we will explore the STRING_AGG function in SQL and we will also reinforce our learning with various examples. STRING_AGG function can be counted as a new member of the SQL aggregation functions and it was announced in SQL Server 2017. STRING_AGG function gathers all expression from rows and then puts it together in these rows expression in order to obtain a string. Additionally, this function takes a separator parameter that allows separating the expressions to be concatenated.

#sql #learnsql #practicalit #sqlserver #sqlservertutorialinhindi