并于触发器的问题!
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'TRI_Update_ClassInfo' AND type = 'TR')
DROP TRIGGER TRI_Update_ClassInfo
go
create trigger TRI_Update_ClassInfo
on ClassInfo_TMP
for insert
as
begin
declare @v_cnt int
set @v_cnt=( select count(*) from classinfo where class_seq= class_seq)
if @v_cnt=0
insert into classinfo(class_seq, class_type, class_name, manager)
--select class_seq,class_type,class_name,manager from inserted
else
update classinfo set class_type=Class_Type, class_name=class_name, manager=manager
where class_seq=class_seq
end
go
上面写的能通过, 但是在 ClassInfo表里只有最前面插入的一条记录, 请问我该怎么写?