System Function in SQL || LEN, SUBSTRING, REPLACE, CONCAT, TRIM
System Function in SQL..
System Functions
Functions that are defined by the system are known as system functions. In other words, all the built-in functions supported by the server are referred to as System functions. The built-in functions save us time while performing the specific task. These types of functions usually work with the SQL SELECT statement to calculate values and manipulate data.
Here is the list of some system functions used in the SQL Server:
String Functions (LEN, SUBSTRING, REPLACE, CONCAT, TRIM)
Date and Time Functions (datetime, datetime2, smalldatetime)
Aggregate Functions (COUNT, MAX, MIN, SUM, AVG)
Mathematical Functions (ABS, POWER, PI, EXP, LOG)
Ranking Functions (RANK, DENSE_RANK, ROW_NUMBER, NTILE)