SQL Server Tutorial

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 »

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 »

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 »

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 »