In SQL Server STRING_SPLIT() is a table-valued function that splits a string into rows of substrings, based on a specified separator character.
Each substring is returned on its own row, in a column called value.
t-sql
How the CHOOSE() Function Works in SQL Server
In SQL Server the CHOOSE() function returns the item at the specified index from a list of values.
Fix SQL Server Error: “The function ‘APPROX_PERCENTILE_CONT’ must have a WITHIN GROUP clause”
If you’re getting SQL Server error 10754 that reads “The function ‘APPROX_PERCENTILE_CONT’ must have a WITHIN GROUP clause” it’s probably because you’re calling the APPROX_PERCENTILE_CONT() function, but you’ve omitted the WITHIN GROUP clause.
To fix this issue, add a WITHIN GROUP clause to the function (and make sure it has an ORDER BY clause).
The Difference Between LEAST() and MIN() in SQL Server
SQL Server 2022 introduced the LEAST() function, which at first glance, may seem to do the same thing as the already existing MIN() function.
However, these are two separate functions with two separate purposes.
Overview of the VARP() Function in SQL Server
In SQL Server the VARP() function returns the statistical variance for the population for all values in the specified expression.
Understanding the VAR() Function in SQL Server
In SQL Server the VAR() function returns the statistical variance of all values in the specified expression.
A Quick Overview of SQL Server’s STDEVP() Function
In SQL Server the STDEVP() function returns the statistical standard deviation for the population for all values in the specified expression.
How to Select the Date Column with the Latest Date in SQL Server
Suppose you have a query that returns multiple date columns, and suppose you want to return the latest date, regardless of which column it came from.
As from SQL Server 2022 we can use the GREATEST() function to easily achieve this outcome.
Understanding the STDEV() Function in SQL Server
In SQL Server the STDEV() function returns the statistical standard deviation of all values in a specified expression.
So we can use this function to get the standard deviation of all values in a column.
An Introduction to SQL Server’s GROUPING_ID() Function
SQL Server has a GROUPING_ID() function that returns the level of grouping based on its arguments.
We pass one or more column expressions to the function, and it computes the level of grouping. The column expressions must match the ones provided by the GROUP BY clause.