Queries SQL Tutorials


thumbnail.png

How to Call the LEN Function on a String in SQL Server 2008 R2

Filed in: Queries, SQL Server

This tutorial will show how to use the LEN function in SQL Server 2008 R2. The LEN function returns the number of characters in an input string, excluding trailing blanks. […]

thumbnail.png

How to Concatenate Non Numerical Columns in SQL Server 2008 R2

Filed in: Queries, SQL Server

This tutorial will show how to use the string concatenation in SQL Server 2008 R2. The string concatenation uses a plus sign(+) operator to concatenate strings. It allows two strings […]

thumbnail.png

How to Use the OVER Clause in SQL Server 2008 R2

Filed in: Queries, SQL Server

This tutorial will show how to use the OVER clause in SQL Server 2008 R2. The OVER clause exposes a window of rows to certain kinds of calculations. The window […]

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 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 Use the GETDATE Function in SQL Server

Filed in: Queries, SQL Server

This tutorial will show you how to use the GETDATE function in SQL Server. The GETDATE function retrieves the current date and time from the SQL Server at run time. […]

thumbnail.png

How to Use Wild Cards in SQL Server

Filed in: Queries, SQL Server

In this tutorial you will learn how to use wildcards in SQL Server. SQL wildcards can be used when searching for data in a database. SQL wildcards are used with the […]

thumbnail.png

How to Use the CASE Expression in SQL Server

Filed in: Queries, SQL Server

In this tutorial you will learn how to use the CASE expression. A CASE expression is given a value that runs through the conditional logic and returns a value. Because […]

Page 1 of 212
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