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