在插入语句中出现语法错误 [英] getting syntax error in insert statement

问题描述

以下 Insert 语句抛出语法错误，但我没有找到.

The following Insert statement is throwing syntax error but I am not finding it.

INSERT INTO Test ( [ID] ,[IDType] ,[IDLanguage] ,[State] ,[StateSEO] ,[Permalink] ,[PermalinkMapping] ,[DateCreated] ,[DateModified] ,[SEOName]) 

VALUES 
( 19988 ,72 ,1 ,0 ,0 ,'' ,'' , GETDATE() , GETDATE() ,'H_KDA1559_ST_004' ) 

推荐答案

这只是一个猜测，但是否有可能您正在使用 Management Studio 查询窗口来执行此操作，并且您碰巧有一部分，但不是全部，尝试执行时选择的查询?那会导致这个错误.

It's just a guess, but is it possible that you are using a Management Studio Query Window to execute this, and you happen to have part, but not all, of the query selected when you try to execute it? That would cause this error.

这篇关于在插入语句中出现语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！