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