我有一个更新语句
UPDATE score
SET scores = 11
WHERE scorePeople = '陈(杭州)' AND byName = '林(苏州)'
像这样带括号的就无法更新记录,为什么?
UPDATE score
SET scores = 11
WHERE scorePeople = '陈(杭州)' AND byName = '林(苏州)'
像这样带括号的就无法更新记录,为什么?
调试欢乐多
SET scores = 11
WHERE scorePeople = N'陈(杭州)' AND byName = N'林(苏州)'
score
SET
scores = 11
WHERE
scorePeople = N'陈(杭州)' AND byName = N'林(苏州)'
UPDATE score
SET scores = 11
WHERE replace(replace(scorePeople,char(10),''),char(13),'')= N'陈(杭州)'
AND replace(replace(byName,char(10),''),char(13),'') = N'林(苏州)'
update score set scores=@scores where byName=@byName and scorePeople=@scorePeople
现在@byName传值“林(苏州)”,@scorePeople传值“陈(杭州)”,这条语句更新不了数据
如果名字后面没有括号的就没有问题
UPDATE score
SET scores = 11
WHERE scorePeople = N'陈(杭州)' AND byName = N'林(苏州)'