自动增加 sql-server 中的非标识列 [英] Auto Increment a non-identity Column in sql-server

问题描述

我们的数据库中有非Identity Column 具有特定值.我们有如下需求，

We have Non-Identity Column in our Database Which have a specific value . We have a requirement as below,

每当记录insert到该列中时，值应加一.

Whenever a record insert into that column, value should be incremented by one.

如何在 sql server 中处理这个问题?

how to handle this in sql server ?

感谢您的帮助.

推荐答案

好吧，你可以使用 SQL Server 2012 中引入的SEQUENCE语句带来了生成ID的方法

Well, you can use SEQUENCE statement introduced in SQL Server 2012 brings the method of generating IDs

要在插入语句中使用它，您需要先像这样创建序列 -

To use it in insert statement, you need to first create sequence like this -

CREATE SEQUENCE dbo.Id_Sequence
    AS INT
    START WITH 1
    INCREMENT BY 1
    MINVALUE 0
    NO MAXVALUE

现在像这样在插入语句中使用它 -

Now use it in your insert statement like this -

INSERT  INTO dbo.Test1
        ( orderid ,
          custid ,
          empid
        )
        SELECT NEXT VALUE FOR dbo.Id_Sequence,
                @custid ,
                @empid

就是这样.

这篇关于自动增加 sql-server 中的非标识列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！