Incorrect syntax in SQL near 'User'

本文关键字：User near syntax in SQL Incorrect | 更新日期: 2023-09-27 18:25:25

我正在尝试写这行：

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

我得到的例外是：

incorrect syntax near the keybord 'User'.

Incorrect syntax in SQL near 'User'

User是MS Sql Server中的保留关键字，必须用方括号[]转义：

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

但不要创建这样的表：在MS SQL Server 中创建保留字/关键字的表名

尝试用方括号包围"用户"：

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