没分了!发不了了!对8起!
CREATE TRIGGER sreg_spzk_up ON spzk
FOR update
ASif @@rowcount=0 return
declare @spzk_up varchar(20)
select @spzk_up zf from insertedif (@spzk_up='yes')
begin
update spkc set mount=spkc.mount-i.mount from spzk i,spkc spkc where spkc.spmc=i.name
update spkc set zje=mount*spkc.dj
end if (@spzk_up='no')
begin
update spkc set mount=spkc.mount+i.mount from spzk i,spkc spkc where spkc.spmc=i.name
update spkc set zje=mount*spkc.dj
end
CREATE TRIGGER sreg_spzk_up ON spzk
FOR update
ASif @@rowcount=0 return
declare @spzk_up varchar(20)
select @spzk_up zf from insertedif (@spzk_up='yes')
begin
update spkc set mount=spkc.mount-i.mount from spzk i,spkc spkc where spkc.spmc=i.name
update spkc set zje=mount*spkc.dj
end if (@spzk_up='no')
begin
update spkc set mount=spkc.mount+i.mount from spzk i,spkc spkc where spkc.spmc=i.name
update spkc set zje=mount*spkc.dj
end
FOR update
ASif @@rowcount=0 return
declare @spzk_up varchar(20)
select @spzk_up=zf from insertedif (@spzk_up='yes')
begin
update spkc set mount=spkc.mount-i.mount from spzk i,spkcwhere spkc.spmc=i.name
update spkc set zje=mount*spkc.dj
end if (@spzk_up='no')
begin
update spkc set mount=spkc.mount+i.mount from spzk i,spkcwhere spkc.spmc=i.name
update spkc set zje=mount*spkc.dj
end
--这样?另外spzk,spkc不用关联吗?
sqldumpexceptionhandler:进程54发生严重的异常
c0000005 EXCEPTION_ACCESS_VIOLATION。SQL Server 将终止该进程。