Author: admin

In this article, Joins(Inner, Outer, Cross) in SQL Server we will learn what are Joins and types of joins like inner, outer, and cross join with examples.

In this article, How to Backup Table Using SELECT INTO Statement we learn how to backup SQL tables with or without data using T-SQL or Graphical User Interface.

In this article, How To Filter Groups Using Having Clause in SQL Server we will group the data by GROUP BY clause and then filter the group by HAVING clause.

Aggregate Functions are built in functions in SQL Server and are applied on set of records. We perform computation on set of values rather than a single value.

In this article, How To Group Data Using Group By in SQL Server we will learn how to group tables data.

In this article, How To Truncate Table in SQL Server we will learn what is a truncate statement and how we can truncate a table in SQL Server.

In this article, How To Delete Data From Table in SQL Server we will learn how to delete one, multiple, or complete records from a table using T-SQL.

In this article, How To Update Table Data in SQL Server we will learn how to update single records, multiple records, or all fields of a column using T-SQL.

In How To Sort Data Using Order By clause in SQL, we will see how to sort or arrange data by one or multiple columns with or without where clause.

In this article, How to select distinct records from SQL Server table using DISTINCT keyword.

In this article, How to Filter Data From Table in SQL Server we will use the WHERE clause in select, updating, and deleting records from a table.

In this article, Round Off Values Using Ceiling and Floor in SQL we will learn how to round off values using ceiling and floor functions in SQL Server.

In this article, How To Find Square Root Of A Number in SQL we will learn how to find the square root of a number using SQRT system function of SQL Server.

In this article, How To Select Data From Table in SQL Server we will learn how to select single, multiple, distinct, wild cards, top n records, etc.

In this article, How To Insert Data in SQL Server Table we will learn how single or multiple records can be inserted using INSERT INTO Statement in a table.

In this article, What is NOT NULL Constraint in SQL Server we will learn how to add NOT NULL Constraint in SQL Server Using T-SQL or GUI.

In this article, "How To Add Check Constraint on SQL Server Table" we will learn how to add check constraints on a table while creating and altering.

The DEFAULT constraint is used to set a default value for a column. The default value will be added to all new records, if no other value is specified.

In this article, Unique Key Constraint in SQL Server we will learn what is unique key constraint and how to add unique key while creating and altering table.

In this article, Foreign Key Constraint in SQL Server we will learn what is a foreign key constraint and how to add on create table and alter table.