sql - Optimal way to concatenate/aggregate strings - Stack Overflow
sql sql-server aggregate-functions string-concatenation edited Dec 3, 2023 at 4:44 Thomas 30.5k 6 99 143
sql - How do I split a delimited string so I can access individual ...
Nov 2, 2015 · Using SQL Server, how do I split a string so I can access item x? Take a string "Hello John Smith". How can I split the string by space and access the item at index 1 which …
How to use GROUP BY to concatenate strings in SQL Server?
SQL Server 2005 and later allow you to create your own custom aggregate functions, including for things like concatenation- see the sample at the bottom of the linked article.
Entity framework EF.Functions.Like vs string.Contains
Aug 14, 2017 · It says that they added new Sql functions like EF.Functions.Like for performing the SQL LIKE operation. I was wondering, what then would be the difference between …
Azure SQL trigger for Functions configuration problem
Jan 24, 2025 · 0 I want to read SQL connection string for Azure Function from Azure App Configuration. I do load setting with: builder.Configuration.AddAzureAppConfiguration(...); And …
aggregate functions - Can we use SQL Server STRING_AGG () in …
Mar 29, 2023 · Aggregate functions that are used with CUBE, ROLLUP, or GROUPING SET queries must provide for the merging of subaggregates. To fix this problem, remove the …
Does T-SQL have an aggregate function to concatenate strings?
Possible Duplicates: Is there an Implode type function in SQL Server 2000? How can I group fields from multiple records in T-SQL by another field? I have a view which I'm querying that …
'STRING_SPLIT' is not a recognized built-in function name
The STRING_SPLIT function is available at compatibility level 130 or higher. If your database compatibility level is lower than 130, SQL Server will not be able to find and execute …
How do I search an SQL Server database for a string?
Dec 8, 2019 · I need to search an SQL Server database for all mentions of a specific string. For example, I would like to search all tables, views, functions, stored procedures, ... for string …
Get unique values using STRING_AGG in SQL Server
May 29, 2018 · sql sql-server sql-server-2017 string-aggregation edited May 29, 2018 at 17:20 marc_s 760k 185 1.4k 1.5k