Question

.net中关于SQL语句使用字符串拼接出现的错误！！！

xm temp 和label20 .Text的都是值为11，是一个存在的表名
......string cmdStr3 = "insert into "+ label20 .Text +"(buyticket) values(@buyticket)";......

......string cmdStr ="select * from "+ xm;......
......string cmdStr = "delete * from "+ temp +" where buyticket=@buyticket";......
这三句的错误提示是： 11附近有错误

Answer 1

如果 11是表名 ，那么应该加[]号；
......string cmdStr3 = "insert into ["+ label20 .Text +"] values(@buyticket)";......
.....string cmdStr ="select * from ["+ xm+"]";......

Answer 2

delete 不需要写*
直接delete from

Answer 3

...

追问

你这个很无语的说？