Max() function in SQL Server

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

SUM() function in SQL Server

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() function in SQL Server

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() function in SQL Server

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

Stuff VS Replace function in SQL Server

Stuff VS Replace function Stuff Function This function is used to replace string from the given start position, passed as 2nd argument with string passed as last argument. In Stuff function, 3rd argument defines the number of characters which are going to be replaced. Syntax:- STUFF ( character_expression , start , length , replaceWith_expression ) […]

Continue Reading