Functions Tagged SQL Tutorials


thumbnail.png

How to Return Previous or Next Values in SQL Server 2008 R2

This tutorial will show how to create a query that returns previous and next values of a table column in SQL Server 2008 R2. Since rows in a table have […]

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 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 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. […]

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