有谁能帮个忙呢?解决马上结贴
有谁能将如下的Oracle转为SQL Server的触发器呢? 在线等待
create or replace trigger tri_classinfo_tmp
after insert on classinfo_tmp for each row
declare
v_cnt number(3);
begin
select count(*) into v_cnt from classinfo
where class_seq=:new.class_seq;
if v_cnt=0 then
insert into classinfo(class_seq,
class_type,
class_name,
manager)
values(:new.class_seq,
:new.class_type,
:new.class_name,
:new.manager
);
else
update classinfo set class_type=:new.class_type,
class_name=:new.class_name,
manager=:new.manager
where class_seq=:new.class_seq;
end if;
end;