곰탱이의 개인블로그

http://msdn.microsoft.com/en-us/library/ff878058(v=SQL.110).aspx

이미 Sequence 에 대한 MSDN 이 잘 나와 있네요.

--Create the Test schema
CREATE SCHEMA Test ;
GO

-- Create a table
CREATE TABLE Test.Orders
    (OrderID int PRIMARY KEY,
    Name varchar(20) NOT NULL,
    Qty int NOT NULL);
GO

-- Create a sequence
CREATE SEQUENCE Test.CountBy1
    START WITH 1
    INCREMENT BY 1 ;
GO

-- Insert three records
INSERT Test.Orders (OrderID, Name, Qty)
    VALUES (NEXT VALUE FOR Test.CountBy1, 'Tire', 2) ;
INSERT test.Orders (OrderID, Name, Qty)
    VALUES (NEXT VALUE FOR Test.CountBy1, 'Seat', 1) ;
INSERT test.Orders (OrderID, Name, Qty)
    VALUES (NEXT VALUE FOR Test.CountBy1, 'Brake', 1) ;
GO

-- View the table
SELECT * FROM Test.Orders ;
GO

이와 함께

Oracle Sequence 부분도 참고해 주세요.

http://www.techonthenet.com/oracle/sequences.php

CREATE SEQUENCE supplier_seq


    MINVALUE 1


    MAXVALUE 
999999999999999999999999999


    START WITH 1


    INCREMENT BY 1


    
CACHE 20;