SQL Server 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 Create a Correlated Subquery in SQL Server 2008 R2

This tutorial will show how to create a correlated subquery in SQL Server 2008 R2. Correlated subqueries are subqueries that refer to attributes from the table that appears in the […]

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 Insert Values into a Table Within a Database in SQL Server 2008 R2

This tutorial will show how to insert values into table within a database. In SQL, there are two ways to insert data into a table:  one row at a time […]

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

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