SQL SERVER2012新功能之SEQUENCE

SQL SERVER2012新增加了SEQUENCE功能:

--创建SEQUENCE

CREATE SEQUENCE [dbo].[Seq1]
AS [int]
START WITH 1
INCREMENT BY 1
MAXVALUE 5000000
GO


--建立测试表：
CREATE TABLE TSeq1(col1 int,col2 varchar(50));
GO


--插入数据：
INSERT TSeq1(col1,col2) VALUES (NEXT VALUE FOR SEQ1,'Seq Test by Leks')
go
select MAX(col1) from TSEQ1 
go 
select current_value from sys.sequences
go
select next value for dbo.seq1
go