如何使SELECT NEXT VALUE在SQL Server中工作？

发布时间：2020-12-12 07:44:56 所属栏目：MsSql教程来源：网络整理

导读：我试图让以下内容在SQL Server中工作时遇到一些困难： CREATE TABLE table_X AS SELECT NEXT VALUE FOR GROUP_A AS GROUP_ID,RISK_ID FROM ( SELECT UNIQUE RISK_ID,FROM table_Y ) SS; 有人告诉我： "Incorrect syntax near the keyword 'SELECT'.""Incorrec

我试图让以下内容在SQL Server中工作时遇到一些困难：

CREATE TABLE table_X AS
    SELECT 
        NEXT VALUE FOR GROUP_A AS GROUP_ID,RISK_ID
    FROM 
        ( SELECT UNIQUE RISK_ID,FROM table_Y ) SS;

有人告诉我：

"Incorrect syntax near the keyword 'SELECT'."
"Incorrect syntax near the keyword 'UNIQUE'."

究竟是什么问题以及如何在SQL Server中解决此问题？

解决方法

CREATE TABLE Person
(
FirstName Varchar(50),LastName Varchar(50)
);

/*
Insert Some Values Into Person
*/

CREATE SEQUENCE CountBy
    START WITH 1
    INCREMENT BY 1 ;

SELECT NEXT VALUE FOR CountBy OVER (ORDER BY LastName) AS ListNumber,FirstName,LastName
    INTO table_x
FROM Person

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!