Typical uses of Oracle sequences

Oracle sequences supply unique numbers that can be used when populating tables. In this article, Jonathan Lewis explains the typical uses of Oracle sequences.

The IDENTITY Column Property

There are a number of ways to generate key values in SQL Server tables including the IDENTITY column property, the NEWID() function and more recently, SEQUENCES. The IDENTITY column property is the earliest of these methods. It was introduced very early in the history of SQL Server and it is arguably the simplest approach. Though old, IDENTITY is still maintained in modern versions of SQL Server and is still relevant for simple use cases.

Identify Missing Sequence/Identity Numbers

This script is used to identify the missing sequence numbers or identity numbers.

SQL Server SEQUENCE Basics

The SEQUENCE statement introduced in SQL Server 2012 brings the ANSI SQL 2003 standard method of generating IDs. This is a great relief to database professionals as it solves some problems what are awkward to solve with the IDENTITY property. Joe Celko explains the basics of using a SEQUENCE.

Sequence

SEQUENCE

New feature in SQL Server 2012 - Sequence

A new feature in SQL Server 2012 is Sequence. A Sequence object provides functionality similar to Identity.

The Sequence Object in SQL Server 2012

The Sequence Object is one of the many exciting new features introduced in SQL Server 2012. Learn what this new feature can do for you and how you can use it.

Sequences in SQL Server 2012

This article describes the sequence new feature used in SQL Server 2012

RE: Changing Field Names in Tables

check out SP_Rename 'OldTableName', 'NewTableName', 'OBJECT' SP_Rename 'dbo.Table.ColName', 'NewName', 'COLUMN'