getting syntax error in insert statement [duplicat

问题:

This question already has an answer here:

• SQL syntax error 170 in insert statement 4 answers

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' ) 

回答1:

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.