主页 / dba / 问题 / 86029
Accepted
SqlWorldWide
Asked: 2014-12-13 07:29:42 +0800 CST

序列函数的下一个值

  • 772

为什么这给我相同的值，四个 1？

USE [TSQL2012]
GO
IF OBJECT_ID('dbo.sqlsequence', 'SO') IS NOT NULL
    DROP SEQUENCE dbo.sqlsequence;
GO
CREATE SEQUENCE [dbo].[SQLSequence] AS INT 
START WITH 1
MAXVALUE 8 CYCLE

SELECT NEXT VALUE FOR
        [dbo].[SQLSequence] AS [Seq1] ,
    NEXT VALUE FOR
        [dbo].[SQLSequence] AS [Seq2] ,
    NEXT VALUE FOR
        [dbo].[SQLSequence] AS [Seq3] ,
    NEXT VALUE FOR
        [dbo].[SQLSequence] AS [Seq4]

但这按预期工作正常。给我 1、2、3、4

USE [TSQL2012]
GO
IF OBJECT_ID('dbo.sqlsequence', 'SO') IS NOT NULL
    DROP SEQUENCE dbo.sqlsequence;
GO
CREATE SEQUENCE [dbo].[SQLSequence] AS INT 
START WITH 1
MAXVALUE 8 CYCLE

SELECT NEXT VALUE FOR
        [dbo].[SQLSequence] AS [Seq1]
SELECT          NEXT VALUE FOR
        [dbo].[SQLSequence] AS [Seq2]
SELECT          NEXT VALUE FOR
        [dbo].[SQLSequence] AS [Seq3]
SELECT           NEXT VALUE FOR
        [dbo].[SQLSequence] AS [Seq4]
sql-server functions

1 个回答

  1. Best Answer

    根据文档说明：

    NEXT VALUE FOR 函数是不确定的，并且只允许在生成的序列值的数量明确定义的上下文中使用。以下是给定语句中每个引用序列对象将使用多少个值的定义：

    SELECT- 对于每个引用的序列对象，在语句的结果中每行生成一次新值。

    • 4

相关问题