CREATE SEQUENCE dbo.OrderIDs
    AS INT
    MINVALUE 1
    NO MAXVALUE
    START WITH 1;
 
SELECT NextOrderID = NEXT VALUE FOR dbo.OrderIDs
UNION ALL     SELECT NEXT VALUE FOR dbo.OrderIDs
UNION ALL     SELECT NEXT VALUE FOR dbo.OrderIDs;

结果：

NextOrderID
-----------
1
2
3

有关原始来源和更多示例,请参阅here.该页面引用sql Server Denali,它是sql 2012的beta版,但语法仍然相同.