帮忙看看这条sql语句 - .NET技术 / ASP.NET

string selectSql = "select * from class_user_xpnews where spmc like '%" + this.txtSpName.Text.Trim() + "%' and sssq='" + businessSquareId + "' and zxqk='" + fitmentid + "'or key like '%"+"是"+"%' ";
提示key关键字附近有错误。

---

string selectSql = "select * from class_user_xpnews where spmc like '%" + this.txtSpName.Text.Trim() + "%' and sssq='" + businessSquareId + "' and zxqk='" + fitmentid + "'or key like '%"+"是"+"%' ";
提示key关键字附近有错误
你给定的条件逻辑有问题

---

观望楼主的结贴率

---

string selectSql = "select * from class_user_xpnews where spmc like '%" + this.txtSpName.Text.Trim() + "%' and sssq='" + businessSquareId + "' and zxqk='" + fitmentid + "'or [key] like '%"+"是"+"%' ";

---

2 3 楼 都正确

---

好了，谢谢kurorolove了

---

引用

key是sql保留关键字，别用它当数据库字段名

同意

---

Key是SQL 保留关键字！

---

帮顶！！！！！！！！！

---

[key]

---

key都用上了，历害

---

key 是sql 保留字 你后面那句 or条件给个括号

---

引用

string selectSql = "select * from class_user_xpnews where spmc like '%" + this.txtSpName.Text.Trim() + "%' and sssq='" + businessSquareId + "' and zxqk='" + fitmentid + "'o