- T-SQL Tutorial
- T-SQL - Home
- T-SQL - Overview
- T-SQL - Data Types
- T-SQL - Create Tables
- T-SQL - Drop Tables
- T-SQL - INSERT Statement
- T-SQL - SELECT Statement
- T-SQL - UPDATE Statement
- T-SQL - DELETE Statement
- T-SQL - WHERE Clause
- T-SQL - LIKE Clause
- T-SQL - ORDER BY Clause
- T-SQL - GROUP BY Clause
- T-SQL - DISTINCT Clause
- T-SQL - Joining Tables
- T-SQL - Sub-Queries
- T-SQL - Stored Procedures
- T-SQL - Transactions
- T-SQL - Indexes
- T-SQL - Functions
- T-SQL - String Functions
- T-SQL - Date Functions
- T-SQL - Numeric Functions
- T-SQL Useful Resources
- T-SQL - Quick Guide
- T-SQL - Useful Resources
- T-SQL - Discussion
T-SQL - Functions
MS SQL Server has many built-in functions to perform processing on string or numeric data. Following is the list of all useful SQL built-in functions −
SQL Server COUNT Function − The SQL Server COUNT aggregate function is used to count the number of rows in a database table.
SQL Server MAX Function − The SQL Server MAX aggregate function allows to select the highest (maximum) value for a certain column.
SQL Server MIN Function − The SQL Server MIN aggregate function allows to select the lowest (minimum) value for a certain column.
SQL Server AVG Function − The SQL Server AVG aggregate function selects the average value for certain table column.
SQL Server SUM Function − The SQL Server SUM aggregate function allows selecting the total for a numeric column.
SQL Server SQRT Function − This is used to generate a square root of a given number.
SQL Server RAND Function − This is used to generate a random number using SQL command.
SQL Server CONCAT Function − This is used to concatenate multiple parameters to a single parameter.
SQL Server Numeric Functions − Complete list of SQL functions required to manipulate numbers in SQL.
SQL Server String Functions − Complete list of SQL functions required to manipulate strings in SQL.