• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
sqlserver tutorial

SQL Server Tutorial

SQL Server Tutorial for Beginners

  • HOME
  • START HERE
  • BASICS
  • ADVANCED
    • Index
    • Views
    • Triggers
    • Stored Procedures
    • User-defined Functions
  • FUNCTIONS

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 Index on Computed Columns

Learning Objective

The objective of this SQL Server tutorial is to teach you what is a computed column and why and how to create an index on a computed column.

What is a Computed Column?

A Computed Column is a column whose values are derived or computed by an expression.… 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 Index with Included Columns

Learning Objective

The objective of this SQL Server tutorial is to teach you how to include non-key columns in an index to improve query performance.

What is SQL Server Index with Included Columns?

The ability to include additional non-key columns in an index to augment its capacity was introduced in SQL Server from SQL Server 2005.… Read More »

  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Interim pages omitted …
  • Go to page 14
  • Go to Next Page »

Primary Sidebar

DATA MANIPULATION

  • SELECT
  • SELECT TOP
  • SELECT DISTINCT
  • OFFSET FETCH
  • ORDER BY
  • GROUP BY
  • BETWEEN
  • LIKE
  • ALIAS
  • HAVING
  • AND
  • OR
  • IN
  • WHERE
  • SELECT INTO
  • INSERT
  • INSERT Multiple rows
  • INSERT INTO SELECT
  • UPDATE
  • DELETE
  • PRIMARY KEY
  • FOREIGN KEY
  • UNIQUE CONSTRAINT
  • NOT NULL CONSTRAINT
  • SUBQUERY
  • CORRELATED SUBQUERY
  • JOINS
  • CROSS JOIN
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN
  • SELF JOIN
  • UPDATE Join
  • CASE
  • COALESCE
  • NULL
  • NULLIF
  • UNION
  • INTERSECT
  • MERGE
  • EXCEPT
  • EXISTS
  • GROUPING SET
  • PIVOT
  • ROLLUP
  • CUBE

DATA DEFINITION

  • CREATE DATABASE
  • DROP DATABASE
  • CREATE SCHEMA
  • ALTER SCHEMA
  • DROP SCHEMA
  • CREATE TABLE
  • RENAME TABLE
  • DROP TABLE
  • TRUNCATE TABLE
  • IDENTITY column
  • Sequence
  • ALTER TABLE ADD Column
  • ALTER TABLE ALTER Column
  • ALTER TABLE DROP Column

Footer

About

SQLServerTutorial.org provides free tutorials and guide on SQL Server for Developers, Database Administrators, and Solution Architects who want to get started SQL Server quickly.

Recent Posts

  • SQL Server DROP VIEW
  • SQL Server Indexed View
  • Check view definition
  • SQL Server Rename View
  • SQL Server List Views

Quick Links

  • About
  • Contact Us
  • Privacy Policy
  • SQL Server Index
  • SQL Server Views
  • Terms of Use

Copyright © 2023 www.sqlservertutorial.org. All Rights Reserved.