SQL Tutorials

Welcome! Take a look at the SQL Tutorial Categories or try a Search of the site!

thumbnail.png

How to Create a Table in a Database in SQL Server 2008 R2

This tutorial will show how to create a table in a database in SQL Server 2008 R2. Creating a table within an appropriate database is an important essential when keeping […]

thumbnail.png

How to Create a Database in SQL Server 2008 R2

This tutorial will show how to create a database in SQL Server 2008 R2. Think of a database as a container of objects such as tables, views, stored procedures, and […]

thumbnail.png

How to Round a Numeric Column to a Specified Decimal Count in SQL Server 2008 R2

Filed in: Queries, SQL Server

This tutorial will show how to round a column to a specified decimal count. This is possible with the ROUND function. The ROUND function is used to round a numeric field […]

thumbnail.png

How to Calculate the Average of a Numerical Column SQL Server

Filed in: Queries, SQL Server

This tutorial will show how to calculate the average of a numerical column with the AVG function in SQL Server. The AVG function returns the average value of a numeric column […]

thumbnail.png

How to Handle Null Values with the COALESCE Function in SQL Server

Filed in: Queries, SQL Server

This tutorial will show how to use the COALESCE function to handle null values at run time. The COALESCE() function is used to specify how we want to treat NULL […]

thumbnail.png

How to Assign Column Aliases in SQL Server

This tutorial will show how to create a table and write a query that assigns aliases to the columns in the table. One of the benefits of using table expressions […]

thumbnail.png

How to Count Distinct Values in a Table In SQL Server

Filed in: Queries, SQL Server

This tutorial will show how to create a query that retrieves a count of unique values in a column of a table. To make this query work, we will use […]

thumbnail.png

How to Create and Use a Derived Table in SQL Server

This tutorial will show you how to create and use a derived table in SQL Server. Derived tables, also known as subqueries, are defined in the FROM clause of an […]

thumbnail.png

How to Alter Tables and Modify Columns in SQL Server

In this tutorial we will show how to use the ALTER TABLE statement to modify columns in a table. We can either add, delete, or modify columns in an existing […]

thumbnail.png

How to Check for Existing Rows in a Subquery in SQL Server

This tutorial will show you how to use the EXISTS predicate and check if a row does or doesn’t exist in a subquery. The EXISTS predicate accepts a subquery as […]

Page 2 of 41234
Server Intellect Server Management

Recent Activity

  • server-intellect


About Us

SQLAtoms.com is a site devoted to bringing you easy to understand, simple to implement tutorials and query examples for SQL.

Learn More About Us