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?
This type of problem is solved easily on MySQL with its GROUP_CONCAT() aggregate function, but solving it on Microsoft SQL Server is more awkward. See the following SO question for …
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 …
sql - LEFT function in Oracle - Stack Overflow
Jul 3, 2012 · LEFT and RIGHT are SQL Server functions that do what LPAD / RPAD do. You may have a user-defined function in your DB, that would explain the slowdown.
'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 …
Azure Functions Database Connection String - Stack Overflow
May 13, 2016 · How do I add or access an app.config file in Azure functions to add a database connection string? If you're not supposed to add an app.config and there is a better way to …
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 …
Use string contains function in oracle SQL query
Dec 3, 2013 · I'm using an Oracle database and I want to know how can I find rows in a varchar type column where the values of that column has a string which contains some character. I'm …
sql - Built-in function to capitalise the first letter of each word ...
This based on several years of perusing the available string-functions in T-SQL and some pretty recent 5-day courses in SQL Server 2008 R2. Of course, I still could be wrong :).