if exists (select 1 from A where id = ??)
begin
    update A set ...... where id = ??
end
else
begin
    insert into A 
    select ....
end

if not exists (select 1 from B where id = ??)
begin
    insert into b
    select .... 
end

------解决方案--------------------
探讨

SQL code



if exists (select 1 from A where id = ??)
begin
    update A set ...... where id = ??
end
else
begin
    insert into A 
    select ....
end

if not exists (select 1 from B wh……


------解决方案--------------------
如果是SQL 2008 直接用MERGE搞定