select id from a where id in (select b.id from (select a.*, b.* from a, b where a.id = b.id and a.name <> b.name))update a set a.name = select a.name from a, b where a.id = b.id
if not exists(XXXX) begin update XXX end else begin XXX end
update a set a.name = b.name from a,b where a.id = b.id and a.name <> b.name
declare @id int, @name varchar(10) set @id=... set @name=... --以上两句为赋值语句,将ID,NAME分别赋给对应的变量 if exists (select 1 from a where id=@id) and not exists (select 1 from b where name=@name) begin update a set id=@id update b set name=@name end
if not exists(XXXX)
begin
update XXX
end
else
begin
XXX
end
update a
set a.name = b.name
from a,b
where a.id = b.id and a.name <> b.name
declare @id int,
@name varchar(10)
set @id=...
set @name=... --以上两句为赋值语句,将ID,NAME分别赋给对应的变量
if exists (select 1 from a where id=@id) and not exists (select 1 from b where name=@name)
begin
update a set id=@id
update b set name=@name
end