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 −

• − 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 list of SQL functions required to manipulate numbers in SQL.

• − Complete list of SQL functions required to manipulate strings in SQL.

Khóa học lập trình tại Toidayhoc vừa học vừa làm dự án vừa nhận lương: Khóa học lập trình nhận lương tại trung tâm Toidayhoc

user