sql - 'NVARCHAR' 附近的语法不正确

Question

CREATE TABLE #temptable
(
    Assessment_Component_Identifier NVARCHAR(50),
    Predecessor_Assessment_Component_Identifier NVARCHAR(50),
    Assessment_Period_Identifier NVARCHAR(50),
    [Level] TINYINT,
    Assessment_Period_dataination_Identifier NVARCHAR(50)
);

INSERT INTO #temptable
(
    Assessment_Component_Identifier NVARCHAR(50),
    Predecessor_Assessment_Component_Identifier NVARCHAR(50),
    Assessment_Period_Identifier NVARCHAR(50),
    [Level] TINYINT,
    Assessment_Period_dataination_Identifier NVARCHAR(50)
);

我收到以下错误

消息 102，级别 15，状态 1，第 11 行
'NVARCHAR' 附近的语法不正确

标签： sqlsql-servertsql

Answer 1

如果要插入#temp表中，则必须仅使用列表中的列名，如下所示：

INSERT INTO #temptable
(
    Assessment_Component_Identifier,
    Predecessor_Assessment_Component_Identifier,
    Assessment_Period_Identifier,
    [Level],
    Assessment_Period_dataination_Identifier
) VALUES (.....);