Database Tagged SQL Tutorials


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

thumbnail.png

How to Use the TOP Option in SQL Server

Filed in: Queries, SQL Server

In this tutorial you will learn how to use the TOP option. The TOP option  is a exclusive T-SQL feature that allows you to limit the number or percentage of […]

thumbnail.png

How to Insert Values into a Table in SQL Server

In this tutorial you will learn how to insert values into a table in SQL Server. If you used any type of database language, whether it be in Visual Studio […]

thumbnail.png

How to Create a Table in SQL Server

Filed in: Queries, SQL Server

Introduction A table in a database is what specifies the information of what the programmer wants to put into the database. There are two ways to create a table, by […]

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