Upto 20% Scholarship on Live Online Classes
SQL Server Functions:
Types of SQL Server Functions:
And in system defined function we have 2 types of functions.
Scalar Functions: Which operators on single value and returns single value, below is the list of some scale functions used in sql server.
|round (9.56785)||This will round the give number to 3 places of decimal, 9.567|
|rand (10)||This will generate random numbers of 10 characters|
|upper (‘sql’)||This will return upper case of given string, ‘SQL’|
|lower (‘SQL’)||This will return lower case of given string, ‘sql’|
|abs (-20.75)||This will return absolute number of a given number, 20.25|
|Convert (int, 20.56)||This will convert given float value to integer, 20|
|ltrim (‘ sql’)||This will remove the spaces from left hand side, ‘sql’|
|rtrim (‘sql ‘)||This will remove the spaces from right hand side, ‘sql’|
|Substr ()||This will extract characters from a text field|
|ASCII (char_Exp)||This will return ASCII code of the given character expression|
Read More: Different Type of SQL Joins
Aggregate Functions: Aggregates the values and return a single value, below is the list of some aggregate values in sql server.
|Min ()||This will return Minimum value|
|Max()||This will return Maximum value|
|Avg ()||This will return Average value|
|Count ()||This will return number of counts|
|Sum ()||This will return total sum of numeric value|
These functions are created by user in the system database, and we have 3 types of user define functions:
Read More: Different Types of SQL Injection
Scalar Function: It is a function that takes one or more values but returns a single value.
Read More: Different Types of SQL Keys
Inline table-Valued function:
It returns a table variable as a result of actions perform by function. The value of table variable should be derived from a single SELECT statement.
Read More: SQL Server Interview Questions
Multi-Statement Table-Valued Function
Multi-statement table-valued function returns a table variable as a result of actions perform by function. In this a table variable, must be explicitly declared and defined whose value can be derived from a multiple sql statements.
I am Kristine, the SQL Server Trainer with JanBask training, I write articles on SQL, its interview questions, its certifciations etc, to help the individuals learn more and more about SQL.