“NVARCHAR"附近的语法不正确 [英] Incorrect syntax near 'NVARCHAR'

问题描述

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' 附近的语法不正确

Msg 102, Level 15, State 1, Line 11
Incorrect syntax near 'NVARCHAR'

推荐答案

如果你想插入到 #temp 表中，那么你必须只使用列表中的列名，如下所示:

If you want to insert into #temp table then you have to use only column names in the list as follows:

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

这篇关于“NVARCHAR"附近的语法不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！