要在insert语句中使用它,您需要首先创建这样的序列 –

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

现在在你的insert语句中使用它 –

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

而已.