SQL Server Tutorial

SQL Server Tutorial for Beginners

SQL Server Basics

This is test category page.

SQL Server ALTER TABLE DROP Column

Learning Objective

The objective of this SQL Server tutorial is to teach you how to use SQL Server ALTER TABLE DROP Column to remove one or more columns from the existing table.

Introduction to SQL Server ALTER TABLE DROP Column

While working in the SQL Server database, sometimes, you may need to remove one or more columns from an existing table.… Read More »

SQL Server ALTER TABLE ALTER Column

Learning Objective

The objective of this SQL Server tutorial is to teach you how to modify one or more columns of a table using SQL Server ALTER TABLE ALTER Column statement.

Introduction to SQL Server ALTER TABLE ALTER Column

Sometimes you may need to modify an existing column of a table.… Read More »

SQL Server ALTER TABLE ADD Column

Learning Objective

The objective of this SQL Server tutorial is to teach you how to use SQL Server ALTER TABLE ADD Column statement to add one or more columns in an existing table in the SQL Server database.

Introduction to SQL Server ALTER TABLE ADD Column

In real-world scenarios, requirements may come like to add one or more columns in an existing table in SQL Server.… Read More »

SQL Server Sequence

Learning Objective

The objective of this tutorial is to teach you how to use the Sequence object in SQL Server to generate a sequence of numeric values in a particular order. 

What is a Sequence

A Sequence is a list of number which is in particular order.… Read More »

SQL Server DROP TABLE

Learning Objective

The objective of this tutorial to teach you, how to remove one or more existing tables using SQL Server DROP TABLE statement.

Introduction to SQL Server DROP TABLE statement

While working with SQL Server on day to day basis, you may need to drop one or more tables which are no longer in use from the database.… Read More »

SQL Server IDENTITY column

Learning Objective

The objective of this tutorial is to teach you how to use SQL Server IDENTITY column in a table of SQL Server.

Introduction of SQL Server IDENTITY column

Identity column in a table defines a column that values increment automatically.… Read More »