[求助] 在Sql语句结尾之后找到字符

从小到大发布于 2007-03-24 15:55， 5607 次点击

update PhoneInfo
set VoteCount=VoteCount+1;
VoteScore=(@VoteScore+VoteCount*VoteScore)/(VoteCount+1)
where PhoneID=@PhoneID

弹出错误窗口在Sql语句结尾之后找到字符

如果有人投票的话重新计算投票的分数本人新学的数据库该如何做？
急救！！

3 回复

suyongtao2007-03-30 09:16

不会,

being2007-03-30 13:11

update PhoneInfo
set VoteCount=VoteCount+1; ----------->这里用","吧??
VoteScore=(@VoteScore+VoteCount*VoteScore)/(VoteCount+1)
where PhoneID=@PhoneID

jxyga1112008-06-20 18:58

替换啊找到'就替换成空