您将如何在 Microsoft SQL Server 中实现序列?

2021-12-05 00:00:00 sql database sql-server sequences

有没有人有在 SQL Server 中实现类似序列的好方法?

Does anyone have a good way of implementing something like a sequence in SQL server?

有时你只是不想使用 GUID，除了它们很丑的事实.也许您想要的序列不是数字?此外，插入一行然后询问数据库数字是什么似乎太hackish了.

Sometimes you just don't want to use a GUID, besides the fact that they are ugly as heck. Maybe the sequence you want isn't numeric? Besides, inserting a row and then asking the DB what the number is just seems so hackish.

推荐答案

Sql Server 2012 引入了 SEQUENCE 对象，它允许您生成与任何表无关的连续数值.

Sql Server 2012 has introduced SEQUENCE objects, which allow you to generate sequential numeric values not associated with any table.

创建它们很容易:

CREATE SEQUENCE Schema.SequenceName
AS int
INCREMENT BY 1 ;

插入前使用它们的示例:

An example of using them before insertion:

DECLARE @NextID int ;
SET @NextID = NEXT VALUE FOR Schema.SequenceName;
-- Some work happens
INSERT Schema.Orders (OrderID, Name, Qty)
  VALUES (@NextID, 'Rim', 2) ;

请参阅我的博客以深入了解如何使用序列:

See my blog for an in-depth look at how to use sequences:

http://sqljunkieshare.com/2011/12/11/sequences-in-sql-server-2012-implementingmanaging-performance/

相关文章