CREATE TRIGGER [insertname] ON [dbo].[T_jmjbzl_jwh]
FOR UPDATE,DELETE
AS
declare @jwhid char,
@zzqid char,
@ttid numeric
if exists(select * from inserted)
begin
declare Mycursor2 cursor for --定义游标
select jwh_id,zzq_id,id from inserted
open Mycursor2
fetch next from Mycursor2 into @jwhid,@zzqid,@ttid
while @@fetch_status=0
begin
update t_jmjbzl set id=convert(numeric,@jwhid+@zzqid+isnull(louzhuang,'00')
+isnull(menpai,'000'))
where tjwh_id=@ttid
fetch next from Mycursor2 into @jwhid,@zzqid,@ttid
end
close Mycursor2
deallocate Mycursor2
end --表1:表2=N:1
if exists(select * from deleted)
begin
delete t_jmjbzl
From t_jmjbzl a,deleted b
where a.tjwh_id=b.id
end