Question

执行修改时关键字 'and' 附近有语法错误.

Answer 1

update rxzzqxx set owner=@owner and softname=@softname and catagory=@catagory and sydw=@sydw and softnumber=@softnumber and djsj=@djsj and otherowner=@otherowner where rjzzqID=@rjzzqID

把set后的and改成逗号,

update rxzzqxx set owner=@owner ,softname=@softname ,catagory=@catagory ,sydw=@sydw ,softnumber=@softnumber ,djsj=@djsj ,otherowner=@otherowner where rjzzqID=@rjzzqID；

补充：

在update或者insert 的时候,有字段不允许为null,但是你传了null过去.