Incorrect syntax in SQL near 'User'

Question

I'm trying to write this line:

SqlCommand MySqlCommand = new SqlCommand(@
   "INSERT INTO User(NAME ,PASSWORD,PUBLISH_FOLDER,ACTIVE,IP,PORT)
            Values ('shula','Aa1234','study','true','1015','8080')"
           , MyConnection);

The exception i get is:

incorrect syntax near the keybord 'User'.

Try putting a space after `USER` in your insert command. Also, please verify that the error message is exactly as it in the question. You appear to have misspellings, which will make it difficult for other people with a similar problem to find your question. — mason, Oct 01 '14 at 20:43

score 7 · Accepted Answer · edited May 23 '17 at 12:13

7

User is a reserved keyword in MS Sql-Server, you have to escape it with square brackets []:

INSERT INTO [User](NAME ,PASSWORD ,PUBLISH_FOLDER,ACTIVE,IP,PORT) Values ('shula','Aa1234','study','true','1015','8080')

But do not create such tables: Creating table names that are reserved words/keywords in MS SQL Server

edited May 23 '17 at 12:13

Community

1
1

answered Oct 01 '14 at 20:44

Tim Schmelter

450,073
74
686
939

score 2 · Answer 2 · answered Oct 01 '14 at 20:44

2

Try surrounding "User" with square brackets:

SqlCommand MySqlCommand = new SqlCommand("INSERT INTO [User](NAME ,PASSWORD ,PUBLISH_FOLDER,ACTIVE,IP,PORT) Values ('shula','Aa1234','study','true','1015','8080')", MyConnection);

answered Oct 01 '14 at 20:44

Dave Mackersie

1,033
10
14

Darn - beaten on the draw! – Dave Mackersie Oct 01 '14 at 20:46

Incorrect syntax in SQL near 'User'

2 Answers2