SQL Server Function includes Aggregate functions, Conversion functions, Analytics functions, Date functions, Logical Functions, String funcitons, and System functions
SQL Server STRING_SPLIT function is used to split a string into a table that consists of rows of substrings based on a specified separator. This function was introduced in SQL Server 2016 .
STRING_SPLIT requires the compatibility level to be at least 130. When the level is less than 130, SQL Server is unable to find the STRING_SPLIT function.
SQL Server ISNUMERIC( ) function is System Functions which is used to check if the expression is valid numeric type or not.
SQL Server Tutorials By Pradeep Raturi : SQL Server CHOOSE Functions is the logical function that returns the item at the specified index from a list of values in SQL Server.
SQL Server Tutorials By Pradeep Raturi : SQL Server IIF function is the logical function that returns one of two parts, depending on the evaluation of an expression.
SQL Server TRY_CAST() Function is a conversion functions that is used to cast a value to a specified data type.
The DENSE_RANK() is a Ranking function that is used to assign ranks to rows in partitions with no gaps in the ranking values.
The RANK() function is a window function that is used to assign a rank to each row in the partition of a result set.
SQL Row_Number() is a ranking function/window function that is used to assign a sequential integer to each row within a partition of a result set. The row number starts with one for the first row in each partition.
SQL STUFF() function is used to delete a sequence of given length of characters from a string and inserting the given sequence of characters from the specified starting index.
Syntax
STUFF(String, Start, Length, Newstring)
String – It is the string to be modified.
Start – The starting index from where the given length of characters will be deleted and new sequence of characters will be inserted.
Length -The number of characters to delete from string
The SQL TRANSLATE() is a string function that is used to replaces a sequence of characters in a string with another sequence of characters.
The function replaces a single character at a time. Until SQL Server 2016, we used use REPLACE() function to replace each character.
SQL SPACE() is a string function that replicates the number blanks that we want add to the given string.
Syntax
SPACE(number)
The DATENAME() function returns a string, navarchar type, that represents a specified date part of date ,it can be a day , month ,year or time of specific date.
SQL DATEFROMPARTS() function is a date function that returns a date value that maps to a year, month, and day values.
SQL Server MAX() function is an aggregate function that is used to find the Maximum or Largest value of a column .
SQL Server MIN() function is an aggregate function that is used to find the smallest or minimum value of a column
SQL Server COUNT() function is an aggreagate function that returns the number of rows in a table . It sets the number of rows or non NULL column values.
SQL Server SUM function is an aggregate that returns the sum of values for any column in a table.
SQL DATEPART() function is used to get a part of any specific date , it could be a day , month ,year or time of specific date.
