update a,b
set a.cinvcode = 'B0101002',b.cinvcode='B0101002'
from cbom a,cbomson b
where a.cinvcode = 'B0102003' and b.cinvcode='B0102003'
以上更新SQL语句,报语法错误,如何修改呢,
set a.cinvcode = 'B0101002',b.cinvcode='B0101002'
from cbom a,cbomson b
where a.cinvcode = 'B0102003' and b.cinvcode='B0102003'
以上更新SQL语句,报语法错误,如何修改呢,
update cbomson set cinvcode = 'B0101002' where cinvcode = 'B0102003'
set cinvcode = 'B0101002'
where cinvcode = 'B0102003' update b
set cinvcode = 'B0101002'
where cinvcode = 'B0102003'
AS
BEGIN
update a
set a.cinvcode = 'B0101002'
from cbom a
where a.cinvcode = 'B0102003' update b
set b.cinvcode='B0101002'
from cbomson b
where b.cinvcode='B0102003'
END
update a
set a.cinvcode = 'B0101002'
from cbom a,cbomson b
where a.cinvcode = 'B0102003' and b.cinvcode='B0102003' update b
set b.cinvcode='B0101002'
from cbom a,cbomson b
where a.cinvcode = 'B0102003' and b.cinvcode='B0102003'
update a
set cinvcode = 'B0101002'
where cinvcode = 'B0102003' update b
set cinvcode = 'B0101002'
where cinvcode = 'B0102003'
update cbom set cinvcode = 'B0101002'
where cinvcode = 'B0102003'
update cbomson set cinvcode = 'B0101002'
where cinvcode = 'B0102003'