Learn database in a simple and easy way.
SQL Functions
Max():- This function gives the maximum value of the selected column Syntax:- Select Max (col1) from table_name In this article, we are going to use the following table for the examples:- CREATE TABLE [dbo]. [Employee]( [Empid] [Int] IDENTITY (1, 1) NOT NULL Primary key, [EmpNumber] [nvarchar](50) NOT NULL, [EmpFirstName] [nvarchar](150) NOT NULL, [EmpLAStName] [nvarchar](150) NULL, […]
Continue Reading
RTRIM():-This function is used to get the string after the removal of all trailing blanks. Syntax:- RTRIM ( character_expression ) For example:- Select RTRIM(‘Vivek Johari ‘) Result:- Vivek Johari (without blank spaces on Right side)
Continue Reading
Sum():- This function is used to get the sum of values of the specified numeric column. Syntax:- Select Sum (column_name) from tablename Example:- In this article, we are going to use the following table for the examples:- CREATE TABLE [dbo]. [Employee]([Empid] [Int] IDENTITY (1, 1) NOT NULL Primary key,[EmpNumber] [nvarchar](50) NOT NULL,[EmpFirstName] [nvarchar](150) NOT NULL,[EmpLAStName] […]
Continue Reading
Round():-This function is used to round a numeric field to the number of decimals specified. Syntax:- ROUND ( numeric_expression , length [ ,function ] numeric_expression :-Expression of the exact numeric or approximate numeric data type category, except for the bit data type. length:- Optional.Must be an expression of type tinyint, smallint, or int. When […]
Continue Reading
Like:- This operator is used in a WHERE clause to search for a specific pattern in the values of the column. In this article, we are going to use the following table for the examples:- CREATE TABLE [dbo]. [Employee]([Empid] [Int] IDENTITY (1, 1) NOT NULL Primary key,[EmpNumber] [nvarchar](50) NOT NULL,[EmpFirstName] [nvarchar](150) NOT NULL,[EmpLAStName] [nvarchar](150) NULL,[EmpEmail] […]
Continue Reading
SQL FUNCTION: – Function in a database can be defined as the code segment consisting of a logical group of SQL statements which takes some input arguments (if required), run in a sequential order and returns the output either in the form of a single value or in the form of a table.Through this article, […]
Continue Reading
In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to complete a task, but still there are many differences between Stored procedure and Functions. These differences can be summarized as follows:- 1) A stored procedure can return a value or it may not return any […]
Continue Reading